Starting with Oracle Database 10g, the Oracle scheduler was greatly improved with the dbms_scheduler package. Replacing the dbms_job with dbms_scheduler offers additional features by adding the ability to tie jobs with specific user-type privileges and roles.
The Oracle built-in job scheduler gives you powerful capabilities for scheduling routine work. Using the scheduler, you can define work to be done, specify when it is to be done, and monitor the work so that you can correct any problems. You can even control the database resources and priority assigned to the jobs you schedule, ensuring that the most important work gets done first, without creating an overwhelming drain on other system activity.
One nice new feature in 11g is the ability to run jobs (batch files, shell scripts, dos commands etc. etc.) on remote servers once the Oracle Scheduler Agent is installed which is a small piece of software very like Oracle client. My next blog will go through the steps to set this up.
This is a list most of the scheduler views:
View |
Description |
*_SCHEDULER_SCHEDULES |
These views show all schedules. |
*_SCHEDULER_PROGRAMS |
These views show all programs. |
*_SCHEDULER_PROGRAM_ARGS |
These views show all arguments defined for all programs as well as the default values if they exist. |
*_SCHEDULER_JOBS |
These views show all jobs, enabled as well as disabled. |
*_SCHEDULER_RUNNING_CHAINS |
These views show all chains that are running. |
*_SCHEDULER_CHAIN_STEPS |
These views show all steps for all chains |
*_SCHEDULER_CHAINS |
These views show all chains. |
*_SCHEDULER_CHAIN_RULES |
These views show all rules for all chains. |
*_SCHEDULER_GLOBAL_ATTRIBUTE |
These views show the current values of Scheduler attributes. |
*_SCHEDULER_JOB_ARGS |
These views show all set argument values for all jobs. |
*_SCHEDULER_JOB_CLASSES |
These views show all job classes. |
*_SCHEDULER_WINDOWS |
These views show all windows. |
*_SCHEDULER_JOB_RUN_DETAILS |
These views show all completed (failed or successful) job runs. |
*_SCHEDULER_WINDOW_GROUPS |
These views show all window groups. |
*_SCHEDULER_WINGROUP_MEMBERS |
These views show the members of all window groups, one row for each group member. |
*_SCHEDULER_RUNNING_JOBS |
These views show state information on all jobs that are currently being run. |
*_SCHEDULER_JOB_LOG |
These views show all state changes made to jobs. |
*_SCHEDULER_WINDOW_LOG |
These views show all state changes made to windows. |
*_SCHEDULER_WINDOW_DETAILS |
These views show all completed window runs. |