Thanks everyone.
The solution I had in mind already was where the job scheduled its own next
run. So we are all thinking along the same lines.
I just preferred something where the scheduler did all the logic on its own and
not the job. But, this will suffice.
Its simple covers the two rules I set out.
Thanks for your thoughts.
From: Ken Naim [mailto:kennethnaim@xxxxxxxxx]
Sent: Wednesday, October 26, 2016 9:48 AM
To: mwf@xxxxxxxx; Lange, Kevin G; Oracle-L@xxxxxxxxxxxxx
Subject: RE: Scheduler
The scheduler doesn't run the job when one is currently running by default and
you can have the scheduler schedule the job for 30 minutes from completion
rather than a fixed time.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark W. Farnham
Sent: Wednesday, October 26, 2016 8:40 AM
To: kevin.lange@xxxxxxxxx<mailto:kevin.lange@xxxxxxxxx>;
Oracle-L@xxxxxxxxxxxxx<mailto:Oracle-L@xxxxxxxxxxxxx>
Subject: RE: Scheduler
It would seem extreme to buy E-biz just for the scheduler. I'm not sure *why*
Oracle does not expose that rich functionality. Perhaps they are satisfied with
the capabilities of the built-in scheduler they have. I've never tried to buy
or have a customer buy just the apps tech stack without any of the functional
products. I don't know if it is even possible.
The specific schedule: Start me x amount of time after I finished, but not
before y amount of time since my last start seems like a basic requirement to
me. So much so that it was in the MOSES papers. A little more advanced is
trying to creep back or skip to a preferred minute of the hour start (which can
be important to avoid job storms exactly on the hour, for example.)
Once upon a time Jeffrey Pugh built a great scheduler, sold it, that company
got bought, etc., and I think the last chain of custody was CA, but I think you
have to buy their whole suite to get it.
It might be worth a try to unbundle it. Maybe Steve Lemme has a clue.
Without knowing whether a good scheduler is available for sale or if there is
already an open source decent solution, I hesitate to suggest a group effort to
build one.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lange, Kevin G
Sent: Tuesday, October 25, 2016 6:08 PM
To: Oracle-L@xxxxxxxxxxxxx<mailto:Oracle-L@xxxxxxxxxxxxx>
Subject: Scheduler
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:
1. IF it has not ran in the last 30 minutes.
2. 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.
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.