Disabling all DBMS_SCHEDULER jobs
Hi ,
When performing test recoveries of a database , I need to prevent database jobs from running application processes such as (a) sending emails; or (b) logging events to a central logging database.
In order to accomplish this, we set the job_queue_processes to zero before opening the database.
Thus no dbms_jobs run on the open instance, but it does not prevent dbms_scheduler jobs from running.
How can we prevent any dbms_scheduler jobs from running?
I have looked at setting the MAX_JOB_SLAVE_PROCESSES attribute using DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE, but this cannot be set to zero.
When performing test recoveries of a database , I need to prevent database jobs from running application processes such as (a) sending emails; or (b) logging events to a central logging database.
In order to accomplish this, we set the job_queue_processes to zero before opening the database.
Thus no dbms_jobs run on the open instance, but it does not prevent dbms_scheduler jobs from running.
How can we prevent any dbms_scheduler jobs from running?
I have looked at setting the MAX_JOB_SLAVE_PROCESSES attribute using DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE, but this cannot be set to zero.
0