DBMS_SCHEDULER
From: Thomas Roach <troach_at_gmail.com>
Date: Wed, 28 Oct 2009 11:23:30 -0400
Message-ID: <b86ffce60910280823l43d62333s79fc5683975b36ba_at_mail.gmail.com>
Hi all,
Date: Wed, 28 Oct 2009 11:23:30 -0400
Message-ID: <b86ffce60910280823l43d62333s79fc5683975b36ba_at_mail.gmail.com>
Hi all,
I am trying to schedule a job in DBMS_SCHEDULER to run the first Sunday of the month that starts after the first Saturday of the month.
So if Sunday is the first of the month, I don't want it to run until the 8th.
On the interval I tried "FREQ=MONTHLY; BYDAY=1SAT+1" But the +1 is not supported. I could do 1SUN but then it would run on the 1st which I do not want. Does anyone have any ideas on how to accomplish what I need in DBMS_SCHEDULER?
Thanks,
Tom
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 28 2009 - 10:23:30 CDT