Stop / Drop Scheduled / Running jobs in Oracle

You can use the DBMS_SCHEDULER package itself to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package.In some cases you will have to use the force option to stop the job.

SQL> SELECT job_name, state FROM DBA_SCHEDULER_JOBS where job_name like '%AT_OS_OPT%'; Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer