How to Stop the Job Scheduler
You can prevent the Job Scheduler from running at startup by
1 |
EXEC DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('SCHEDULER_DISABLED', 'TRUE'); |
This method will not prevent the use of DBMS_SCHEDULER.RUN_JOB. If someone use DBMS_SCHEDULER.RUN_JOB, the job will execute regardless of the setting of the SCHEDULER_DISABLED attribute
If you want to also stop the jobs which is created by DMBS_JOBS, you need to issue:
1 |
ALTER SYSTEM SET job_queue_processes=0; |