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

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 14 Jun 2005 10:27:58 +0200
Message-ID: <d8m4ee$ku4$1@news.BelWue.DE>

Jeremy wrote:
> 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?
>

Why don't you try?

Holger Received on Tue Jun 14 2005 - 03:27:58 CDT

This message: [ Message body ]
Next message: baka: "Re: in PL/SQL : String replace on some condiations - i hate IF ELSE"
Previous message: Jeremy: "Re: in PL/SQL : String replace on some condiations - i hate IF ELSE"
In reply to: Jeremy: "DBMS_JOB.RUN - requires spare job queue slot?"
Next in thread: Dmitry E. Loginov: "Re: DBMS_JOB.RUN - requires spare job queue slot?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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