Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Terminate Jnnn process in DBMS_JOB

RE: Terminate Jnnn process in DBMS_JOB

From: Graeme Farmer <>
Date: Tue, 15 Jun 2004 10:22:03 +1000
Message-ID: <>


shutdown immediate will terminate the JQ process for you along with any other server processes that are currently connected, rolling back current transactions.

if you need to, you can stop the next iteration by setting job_queue_processes=0 and terminate the existing job manually (alter system kill session 'sid,serial#') then shut down the database but that's a long winded way of doing what Oracle will do for you by performing a shutdown immediate!

For really stubborn processes (ie alter system kill session doesn't manage to budge them) then look into the orakill command for Oracle on Windows. It will terminate threads within the process with much less discrimination!!


-----Original Message-----

From: Connie Zhang [] Sent: Tuesday, 15 June 2004 4:06 AM
Subject: Terminate Jnnn process in DBMS_JOB

I have orcl on WIN2K platform

According oracle documentation about DBMS_JOB in 9i JOB_QUEUE_INTERVAL is obsolete.
If the JOB_QUEUE_PROCESS initialization is greater than 0, the CJQ0 process remains actives, scanning the job queue for available work, so the JOB_QUEUE_INTERVAL processes is no longer needed. When CJQ0 finds work waiting
to be done, it starts more Jnnn processes automatically, up to the limit specified by the initialization parameter JOB_QUEUE_PROCESSES. when a Jnnn process finishes execution of a job, it polls for another job to execute. If there are no jobs selected for execution, it enters an idle state,
but wakes up periodically to poll again. If after a predetermined number of tries, it still finds no jobs to execute, it terminates.

what is a predetermined number of tries here, can we change it? and how?

I have
job_queue_processes = 1 in the parameter level

I have an auditing application which have a dbms_job which set interval as sysdate+1/24/60*1

When we want to shutdown database cleanly, it always have a child processes are named Jnnn where nnn starts at 000 and increments by 1 running...

how can we terminate these Jnnn process? Can we change total time consuming for a predetermined number of tries?

Wish any of one pls share your solution. Thanks!


Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at


This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Limited unless expressly stated otherwise.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Mon Jun 14 2004 - 19:19:01 CDT

Original text of this message