The DBMS_JOB package is built automatically when
the CATPROC.SQL script is run during a database creation. The
DBMS_JOB package includes the procedures shown in Figure 1.
|
Object |
Object Type |
Purpose |
|
BROKEN |
Procedure |
Prevent a job from executing |
|
CHANGE |
Procedure |
Change a jobs characteristics |
|
INTERVAL |
Procedure |
Change a jobs execution interval |
|
ISUBMIT |
Procedure |
Allow submission of job |
|
NEXT_DATE |
Procedure |
Change the next date value for a job |
|
REMOVE |
Procedure |
Remove a non-executing job from the
queue |
|
RUN |
Procedure |
Force a job to execute |
|
SUBMIT |
Procedure |
Submit a job to the job queues |
|
USER_EXPORT |
Procedure |
Export a job definition command for the
specified job |
|
WHAT |
Procedure |
Changes the what string for a job (what
it does) |
