|Oracle® Database Administrator's Guide
11g Release 2 (11.2)
|PDF · Mobi · ePub|
DBMS_JOB is a PL/SQL package that you use to schedule jobs. It is replaced by Oracle Scheduler, which is more powerful and flexible. Although Oracle recommends that you switch from
DBMS_JOB to Oracle Scheduler,
DBMS_JOB is still supported for backward compatibility.
JOB_QUEUE_PROCESSES initialization parameter specifies the maximum number of processes that can be created for the execution of jobs. Beginning with Oracle Database 11g Release 1,
JOB_QUEUE_PROCESSES defaults to 1000. The job coordinator process starts only as many job queue processes as are required, based on the number of jobs to run and available resources. You can set
JOB_QUEUE_PROCESSES to a lower number to limit the number of job queue processes.
JOB_QUEUE_PROCESSES to 0 disables
DBMS_JOB jobs and
DBMS_JOB and Oracle Scheduler (the Scheduler) use the same job coordinator to start job slaves. You can use the
JOB_QUEUE_PROCESSES initialization parameter to limit the number job slaves for both
DBMS_JOB and the Scheduler.
JOB_QUEUE_PROCESSES is 0, both
DBMS_JOB and Oracle Scheduler jobs are disabled.
Oracle Database Reference for more information about the
JOB_QUEUE_PROCESSES initialization parameter