Serializing of dbms_scheduler event based jobs
From: Jaromir D.B. Nemec <jaromir_at_db-nemec.com>
Date: Thu, 12 Jan 2012 01:28:34 +0100
Message-ID: <FB87006DE95249EA8E951EA276B495B7_at_ADLA>
Hi All,
Date: Thu, 12 Jan 2012 01:28:34 +0100
Message-ID: <FB87006DE95249EA8E951EA276B495B7_at_ADLA>
Hi All,
The default behaviour of DBMS_SCHEDULER event-based jobs is to ignore the
event if the job is running at the time of a new event.
There is possibility to run the jobs in parallel using the job attribute
PARALLEL_INSTANCES set to TRUE.
The question is how to obtain serialized event based jobs - i.e. the event
is not ignored if the job is running, but the start of the job is delayed
until the previous job is finished.
Of course the job itself can do some locking to enforce the serialization -
but is there some more simple and native way?
Kind regards,
Jaromir D.B. Nemec
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 11 2012 - 18:28:34 CST