Skip navigation links

MySQL Forums :: Events (Job Scheduler) :: Schedule an event for N Wednesdays in a month for N years


Advanced Search

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 2521 My SQL 11/09/2011 08:04AM
Re: Schedule an event for N Wednesdays in a month for N years 1114 Devart Team 12/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.