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