- Disable
- dbms_job
alter system set job_queue_processes=0; - dbms_scheduler
exec dbms_scheduler.set_scheduler_attribute('scheduler_disabled','true'); - Enable
- dbms_jobalter system set job_queue_processes=10;
- dbms_scheduler
exec dbms_scheduler.set_scheduler_attribute('scheduler_disabled','true');
Tuesday, July 17, 2012
Disable or Enable all Oracle jobs
There are two kinds of jobs dbms_job and dbms_scheduler jobs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment