MySQL Forums
Forum List  »  Events (Job Scheduler)

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Schedule an event for N Wednesdays in a month for N years
4282
November 09, 2011 08:04AM


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.