Scribd
Upload
14 views1 page

192 Split Oracle

The document discusses schedules for running jobs. Schedules specify attributes like start and end times or repeating intervals. Schedules can be combined or use events to trigger jobs. Using schedules allows managing execution of multiple jobs by modifying just the schedule.

Uploaded by

agnesmonalisa11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views1 page

192 Split Oracle

The document discusses schedules for running jobs. Schedules specify attributes like start and end times or repeating intervals. Schedules can be combined or use events to trigger jobs. Using schedules allows managing execution of multiple jobs by modifying just the schedule.

Uploaded by

agnesmonalisa11
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Your Basic Work Flow (continued)

Creating and Using Schedules (continued)


The schedule specifies attributes about when the job is run, such as:
• A start time, which defines when the job is picked for execution and an end time, which
specifies the time after which the job is no longer valid and is not scheduled any more
• An expression specifying a repeating interval for the job
• A complex schedule created by combining existing schedules
• A condition or change in state, called an event, that must be met before the job is started
By using a schedule (instead of specifying the execution times for a job within the job definition),
you can manage the scheduled execution of multiple jobs without having to update multiple job
definitions. If a schedule is modified, each job that uses that schedule automatically uses the new
schedule.

Oracle University and Egabi Solutions. use only


3. Creating and Running a Job
A job is a combination of a schedule and a description of what to do, along with any additional
arguments that are required by the job. There are many attributes that you can set for a job. Attributes
control how the job executes.

THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS
COMPUTER IS STRICTLY PROHIBITED
Oracle Database 11g: Administration Workshop II 17 - 6

You might also like