Title: Section 14 - Recognizing and Managing Dependencies
Course: Dept MC - ADVANCED ORACLE PL/SQL > Section: Unit 5 - Advanced Oracle PL/SQL

On many occasions, you, as a database administrator, or your users will need to automate scheduling and running jobs of many kinds—for example, performing maintenance work such as database backups, data loading and validation routines, generating reports, collecting optimizer statistics, or executing business processes.

The Scheduler facility can be used to schedule tasks to be run at some point in the future. The Scheduler can be coupled with the Resource Manager. It can activate Resource Manager plans and run jobs with priorities assigned to various Resource Manager consumer groups.

Section 14 Learning Outcomes:

- Create a job, program, and schedule
- Use a time-based or event-based schedule for executing Scheduler jobs
- Create lightweight jobs
- Use job chains to perform a series of related tasks
- Create Windows and Job Classes
- Use advanced Scheduler concepts to prioritize jobs

One of the most important things to be successful in this course is to learn to navigate and locate assignments and information.  When in doubt, go to Modules!