Enable or Disable the DBMS Scheduled Jobs in Oracle


Check the status of DBMS Scheduled Jobs


SELECT JOB_NAME, OWNER, ENABLED FROM DBA_SCHEDULER_JOBS;

Enable the DBMS Scheduler jobs


exec dbms_scheduler.enable('JOB_NAME');

Disable the DBMS Scheduler Jobs


execute dbms_scheduler.disable('job_name');

Enable all the DBMS Scheduler jobs


begin
-- Use cursor to get list of scheduler jobs 
for r in ( select job_name from dba_scheduler_jobs)
loop
dbms_scheduler.enable(name => r.job_name, force => true);
end loop;
end;
/

Disable all the DBMS Scheduler jobs


begin
-- Use cursor to get list of scheduler jobs 
for r in ( select job_name from dba_scheduler_jobs)
loop
dbms_scheduler.disable(name=> r.job_name, force => true);
end loop;
end;
/




If you like please follow and comment