Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

Removing a Job From the Job Queue

To remove a job from the job queue, use the REMOVE procedure in the DBMS_JOB package.

Removing a Job: Example

Remove job number 14144 from the job queue.

DBMS_JOB.REMOVE(14144);

Restrictions

You can remove currently executing jobs from the job queue. However, the job will not be interrupted, and the current execution will be completed.

You can remove only jobs you own. If you try to remove a job that you do not own, you receive a message that states the job is not in the job queue.

Additional Information: The parameters for the procedure DBMS_JOB.REMOVE are described in Table 12 - 34.


Contents Index Home Previous Next