About

Martin Klier

usn-it.de

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

Find out your character set in Oracle DB
New theme

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.