What is Job Scheduling and How to do it?

Oracle Apps Interview QuestionsCategory: AOL-SysAdminWhat is Job Scheduling and How to do it?
Questions Master asked 4 years ago
1 Answers
Shailender Thallam Staff answered 4 years ago

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:

  1. Schedule job execution based on time or events
  2. Schedule job processing in a way that models your business requirements
  3. Manage and monitor jobs
  4. 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