Skip to content

How to Disable All Scheduler Jobs

In the previous post, we introduce a way to disable AUTOTASK jobs to prevent them from impacting other running processes.

However, AUTOTASK jobs are only a part of scheduler jobs, and you're not likely to turn them off one by one. So the question is, how to turn off all jobs in a second?

If you want to disable all scheduler jobs definitely and know all the consequences, you may set JOB_QUEUE_PROCESSES to 0 to stop initiating any job process.

Let's see some cases.


JOB_QUEUE_PROCESSES can be set to 0 temporarily.

SQL> alter system set job_queue_processes=0 scope=memory;

System altered.

Memory and SPFILE

JOB_QUEUE_PROCESSES can also be set to 0 persistently.

SQL> alter system set job_queue_processes=0 scope=both;

System altered.


If the database is a RAC DB, you may set it to zero in all instances.

SQL> alter system set job_queue_processes=0 scope=both sid='*';

System altered.

All done!

Leave a Reply

Your email address will not be published. Required fields are marked *