| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Terminate Jnnn process in DBMS_JOB
Connie,
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!!
Regards,
Graeme.
-----Original Message-----
From: Connie Zhang [mailto:connie.zhang_at_verizon.net]
Sent: Tuesday, 15 June 2004 4:06 AM
To: oracle-l_at_freelists.org
Subject: Terminate Jnnn process in DBMS_JOB
I have orcl 9.2.0.4 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.
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...
Wish any of one pls share your solution. Thanks!
Connie
--
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.
 |
 |