Oracle DBMS_JOB.REMOVE
In Oracle, you can remove a job from the job queue using the Oracle
DBMS_JOB.REMOVE statement. Here is an example of the DBMS_JOB.REMOVE
statement:
EXEC DBMS_JOB.REMOVE(123);
The above DBMS_JOB.REMOVE statement will remove job 123 from the job
queue.
If the job you would like to remove is running at the time you
execute the DBMS_JOB.REMOVE statement it will continue to run until
stopped. If you are unable to stop the job, or it does not stop on its
own, you may wish to
kill your Oracle session.
See these links related to DBMS_JOB.REMOVE:
DBMS_JOB
DBMS_JOB.BROKEN
