 |
|
Oracle Tips by Burleson |
Chapter 1 -
Overview of Oracle Job Scheduling
Oracle 10g Scheduler Overview
If the parameter is set to a non-zero value, the job coordinator
will run permanently, but the value will only constrain the number
of job slaves that can be started to run jobs scheduled using the
dbms_job package. The value has no affect on the number of job
slave processes that are allocated to jobs scheduled using the
dbms_scheduler package.
The next section will provide a brief
comparison of the features available in the old and in the new style
Oracle schedulers.
Features Comparison between
dbms_job and dbms_scheduler
The Oracle 10g scheduler has significantly more
functionality than its predecessor, which invariably results in it
having a significantly more feature rich API. The following table,
Table 1.1, provides a brief feature comparison between the
dbms_job and dbms_scheduler packages.
|
Feature |
dbms_job |
dbms_scheduler |
|
Schedule jobs based on anonymous PL/SQL
blocks. |
Yes |
Yes |
|
Schedule jobs based on PL/SQL
procedures. |
Yes |
Yes |
|
Schedule jobs based on operating system
command and executable scripts. |
No |
Yes |
|
Schedule reoccurring jobs with a repeat
interval based on a PL/SQL expression that equates to a DATE
or TIMESTAMP. |
Yes |
Yes |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
