Scheduling
Starting with Oracle 8, Oracle includes a fairly simple mechanism for scheduling tasks inside the database using DBMS_JOB. With the introduction of Oracle 10g, Oracle adds the new DBMS_SCHEDULER command.
DBMS_JOB
To use the DBMS_JOB command, scheduled tasks must be coded as anonymous PL/SQL blocks, procedures, or packaged procedures. The scheduler is controlled via the DBMS_JOB package, and each user automatically has his/her own private job queue.
The main procedures used from the DBMS_JOB package are listed in Table 4-1:
| Procedure | Description |
|---|---|
| SUBMIT | Submits a job to the queue. |
| REMOVE | Removes an existing job from the queue. |
| CHANGE | Alters one or more attributes of a queued job. The job's task, next execution ... |
Get Oracle® DBA Automation Quick Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
