Oracle PL/SQL for DBAs

Managing the Calendar and Schedule

In the previous section, I focused on the first basic component of scheduling: the job. In this section, I’ll explore the second key component (and the most visible one), the schedule, which is the definition of times when a job is supposed to run. You can specify the schedule when you create a job with the CREATE_JOB procedure either by entering a calendar string as the value of the repeat_interval parameter or by referencing a named schedule that you have already created.