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,

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-l
Received on Wed Jan 11 2012 - 18:28:34 CST

Original text of this message