📋Steps in this guide1/1

How to Disable All Scheduler Jobs

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.

oracle configurationintermediate

by OracleDba

11 views

Overview

JOB_QUEUE_PROCESSES can also be set to 0 persistently. If the database is a RAC DB, you may set it to zero in all instances.

Code/Command (click line numbers to comment):

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

System altered.

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

System altered.

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

System altered.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!