Wednesday 7 June 2017

How to stop currently running oracle scheduled jobs?

begin
   dbms_scheduler.stop_job('<JOB_NAME>',true);
end;


example

begin
   dbms_scheduler.stop_job('PRJ_EMP_UPDATE',true);
end;

once after stopping the job, we can disable it from the PL/SQL developer.

No comments:

Post a Comment