Re: DBMS_JOB.RUN - requires spare job queue slot?

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Tue, 14 Jun 2005 12:34:20 +0400
Message-ID: <d8m4o8$82$1@news.caravan.ru>

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1d189a30dc97d0b9989eb8_at_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?

It will be run immediately in your session independently from job_queue_processes parameter value and number of jobs running currently.

Be noticed: DBMS_JOB.RUN will reset state of packages in your session.

Dmitry.

>
> --
>
> jeremy
Received on Tue Jun 14 2005 - 03:34:20 CDT