Disabling/enabling general job execution before/after maintenance
April 27, 2017 Leave a comment
During the maintenance you may need to disable jobs.
To disable jobs created by dbms_jobs set job_queue_processes to zero.
–Save old value
show parameter job_queue_processes 1000
–disable
alter system set job_queue_processes=0;
If you are using dbms_scheduler, this parameter does not work for you.
You will have to run the following:
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
After finishing maintenance, enable them:
alter system set job_queue_processes=1000; dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','FALSE');