The Scheduler enables database administrators to full fill business tasks in an organized and controlled fashion.
To achieve job scheduling Oracle provides a collection of functions and procedures in the DBMS_SCHEDULER package.
Below are the major this a Scheduler can do:
- Schedule job execution based on time or events
- Schedule job processing in a way that models your business requirements
- Manage and monitor jobs
- Execute and manage jobs in a clustered environment
For More information on Scheduler, go through this post http://oracle-base.com/articles/10g/scheduler-10g.php