Oracle7 Server Distributed Systems Volume II: Replicated Data
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.