Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOB.RUN - requires spare job queue slot?

DBMS_JOB.RUN - requires spare job queue slot?

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Tue, 14 Jun 2005 08:40:06 +0100
Message-ID: <MPG.1d189a30dc97d0b9989eb8@news.individual.net>


Version: Oracle 9iR2

If you have job_queue_processes set to e.g. 3 and there are 3 jobs running under DBMS_JOB, will a call to DBMS_JOB.RUN for a 4th job be held pending availability of a slot or will it run immediately?

-- 

jeremy
Received on Tue Jun 14 2005 - 02:40:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US