JOB_QUEUE_PROCESSES parameter

In our company we came across duplicative jobs that have been executed by the system. After an investigation, we find out that, these jobs were run from our test databases. Instead of drop all jobs from the databases, it is easy to set the JOB_QUEUE_PROCESSES parameter to 0.  So, you can use the below code for this.

ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
Posted in DBA
Leave a Reply

Your email address will not be published.