Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Howto make dbms_scheduler job/program incompatible with itself

Henrik BrokvistApr 20 2012 — edited Apr 20 2012
Hi I am wondering how I can make a dbms_scheduler job/program incompatible with itself?

What I want to achieve is that I do not want the scheduler start the next instance of a job if the previous one has not finished.
I have a schedule to run a job every 5 minutes, but I do not want the scheduler to start the next job instance before the previous one
has finished (to make the job incompatible with itself).

I am running on 11gR2

Thanks
Henrik Brokvist
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2012
Added on Apr 20 2012
6 comments
718 views