DBMS_SCHEDULER

  • From: Thomas Roach <troach@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Oct 2009 11:23:30 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » DBMS_SCHEDULER - Thomas Roach