DBMS_JOB
Schedules and manages jobs in the database job queue.
Note
Oracle recommends using the DBMS_SCHEDULER
package.
Procedures
The most relevant procedures are:
SUBMIT
: submits a new job to the job queueRUN
: forces a specified job to runNEXT_DATE
: alters the next execution time for a specified jobBROKEN
: deletes a job executionREMOVE
: removes the specified job from the job queue
Get Oracle Database 11gR2 Performance Tuning Cookbook 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.