Remove the oracle dbms job from the queue

To remove oracle job created using dbms_job, we can use remove with the job id as
EXEC DBMS_JOB.REMOVE(jobno);

There are two types of jobs available in oracle to schedule a job namely dbms_job.submit and DBMS_SCHEDULER.CREATE_JOB, the later being more powerful and havimg better advantages compared among them.

This explains how to remove the scheduled oracle job using DBMS_SCHEDULER

this explains how to remove the job scheduled in oracle from the queue through

Remove the oracle dbms job from the queue  (1473 Views)