Scheduler
Date: Tue, 25 Oct 2016 22:07:39 +0000
Message-ID: <9FEE65EE2766CC4A85A8AE7A8EAF0A0D5738B0F4_at_APSWP0431.ms.ds.uhc.com>
Database: Oracle 12.1.0.2
OS: Linux
I have a condition on multiple databases where a job runs for different lengths of time depending on the size of the particular database. What I need is to be able to schedule a job to run multiple times during the day but ONLY if two conditions are met:
- IF it has not ran in the last 30 minutes.
- IF it is not currently running. So basically, I need to be able to code the Oracle Scheduler correctly with a varying start time on the job that looks to see if its not running now and if there is at least 30 minutes since it last ran.
Anyone have any GOOD Oracle Scheduler resources that can help me set up those kind of dependencies without having to rely on any kind of flag or storage history ? (Just a link to a location that I can study up on would be fine).
I do have ways to do this, but I was hoping for a nice elegant solution using just the scheduler itself.
Thanks in advance
Kevin Lange
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 26 2016 - 00:07:39 CEST