Terminate Jnnn process in DBMS_JOB

From: Connie Zhang <connie.zhang_at_verizon.net>
Date: Mon, 14 Jun 2004 14:05:55 -0400
Message-Id: <20040614180555.VUBO3317.out006.verizon.net@outgoing.verizon.net>

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.

---

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!

Connie

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jun 14 2004 - 13:03:50 CDT