How to kill a running job (scheduled job) ?

Killing Oracle Scheduling Sessions when:

— Find the job
select * from dba_scheduler_running_jobs;

— Kill the job:
exec DBMS_SCHEDULER.STOP_JOB(job_name => ‘owner.job_name’,force => TRUE);

— It can take some minutes
select * from dba_scheduler_running_jobs;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.