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,

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?



Received on Wed Oct 28 2009 - 10:23:30 CDT

Original text of this message