Summary
In this chapter, we examined the various uses of Oracle Scheduler and, ultimately, the power of the Oracle Scheduler when used in real-world scenarios.
We covered:
How to dequeue the Scheduler event queue
How to save the events for debugging
How to specify
job_weightfor a job with parallelismHow to specify
job_priorityHow to specify
max_job_durationHow to specify which events should be generated by a job
How to interpret
job_completedHow to make use the
max_runsjob attributeHow to make use the
end_datejob attributeHow to make use of the
auto_dropjob attributeHow to generate the job names using a prefix
How to use the Scheduler for advanced backup setups
How to use the Scheduler to generate object statistics without impacting the other users
How to create a schedule
How to combine schedules to make advanced schedules
There seems to be only one limitation of the Oracle Scheduler—our lack of imagination to make it work to its full advantage. I hope now it's overcome. The only known limitation...
