Automating Tasks with the Scheduler in Oracle || Admin II Chapter No 17
After completing this lesson, you should be able to:
Simplify management tasks by using the Scheduler
Create a job, program, and schedule
Monitor job execution
Use a time-based or event-based schedule for executing Scheduler jobs
Describe the use of windows, Many tasks in the Oracle environment need job-scheduling capabilities. Routine database maintenance and application logic require jobs to be scheduled and run periodically. Business-to-business (B2B) applications require scheduling for their business events. DBAs need to schedule regular maintenance jobs in specified time windows.
The Oracle database provides advanced scheduling capabilities through the database Scheduler, which is a collection of functions and procedures in the DBMS_SCHEDULER package. The Scheduler can be invoked in any SQL environment, or through Enterprise Manager (EM).
The Scheduler enables database administrators and application developers to control when and where various tasks take place in the database environment. These tasks can be time consuming and complicated; using the Scheduler, you can manage and plan these tasks.
Scheduler jobs can be started based on time or when a specified event occurs, and the Scheduler can raise events when a job’s state changes (for example, from RUNNING to COMPLETE). You can also use a named series of programs that are linked together for a combined objective.
window groups, job classes, and consumer groups
Use email notification
Use job chains to perform a series of related tasks
Describe Scheduler jobs on remote systems
Use advanced Scheduler concepts to prioritize jobs