Moving from DBMS_JOB to DBMS_SCHEDULER - Oracle 10g

This section illustrates some examples of how you can take jobs created with the DBMS_JOB package and rewrite them using the DBMS _SCHEDULER package.

Creating a Job

An example of creating a job using DBMS _JOB is the following:

An equivalent statement using DBMS _SCHEDULER is the following:

Altering a Job

An example of altering a job using DBMS_JOB is the following:

This changes the action for job 31 to insert a different value. An equivalent statement using DBMS_SCHEDULER is the following:

Removing a Job from the Job Queue

The following example removes a job using DBMS_JOB, where 14144 is the number of the job being run:


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics