Disabling (or enabling) general job execution in Oracle 10g

Hi,

disabling and enabling job execution in Oracle DB has two ways: If you are using dbms_jobs, it’s handy to set job_queue_processes to zero to disable the execution of jobs, and set it to a value >0 (maybe 100) to enable.

If you are using dbms_scheduler, this parameter does not work for you. You will have to use package functions to disable

dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');

or to enable

dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','FALSE');

job execution. Keep the reverse sense of the TRUE/FALSE parameters in mind (you are deciding whether to DISABLE the scheduler or not)!

Hope this helps
Usn




You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply