Schedule an event for N Wednesdays in a month for N years
Posted by:
My SQL
Date: November 09, 2011 08:04AM
Hi all,
I need an event that will call N stored procedures on a specific Wednesdays in a month at a specific time (say; 7am) for N years.
example, the event should kick on the following Wednesdays:
9/11/2011
23/11/2011
7/12/2011
21/12/2011
4/01/2012
18/01/2012
1/02/2012
15/02/2012
29/02/2012
...basically it should follow this sequence; 1 Wednesday YES, 1 Wednesday NO; 1 Wednesday YES, 1 Wednesday NO; 1 Wednesday YES, 1 Wednesday NO....
Your help is highly appreciated.
Thanks
Subject
Written By
Posted
Schedule an event for N Wednesdays in a month for N years
November 09, 2011 08:04AM
December 05, 2011 10:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.