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… Read More »How to Disable All Scheduler Jobs
Job
JOB_QUEUE_PROCESSES, How and Why
JOB_QUEUE_PROCESSES is an initialization parameter which controls the maximum number of processes of scheduler jobs in an instance. In this post, we'll talk about the… Read More »JOB_QUEUE_PROCESSES, How and Why
How to Resolve ORA-23421: job number is not a job in the job queue
ORA-23421 When I tried to remove a given job from the queue, the statement failed with ORA-23421, and ORA-06512 are also in the error stack.… Read More »How to Resolve ORA-23421: job number is not a job in the job queue