Oracle Scheduler Concepts

Oracle provides advances scheduler capabilities through the database Scheduler. To simplyfy management tasks, as well as offering a high rich set of functionality for complex scheduling needs, Oracle provides a collection of functions and procedures in the DBMS_SCHEDULER package. Collectively, these functions are called the Scheduler, and they are callable from any PL/SQL program.

What can the Scheduler Do ?

The Scheduler provide complex enterprise scheduling functionality, which you can use to:

1. Schedule job execution based on time.

2. Reuse existing programs and schedules

3. Schedule job processing in a way that models your business requirements

4. Manage and monitor jobs

5. Execute and manage jobs in a clustered environment

Thanks/

A.F.MD.IQBAL

Sr. Programmer

STANDARD GROUP