Skip navigation links

MySQL Forums :: Events (Job Scheduler) :: Event Scheduler will not start automatically


Advanced Search

Re: Event Scheduler will not start automatically
Posted by: Simon Sellick ()
Date: December 06, 2010 11:31AM

I believe that your script requires that the event handler is executing at exactly the time the date changes (I'm not sure what granularity CurDate() has).

If you alter the delete WHERE condition to CouponExpDate <= CurDate() I think that it is more likely to catch it when it runs each day.

Options: ReplyQuote


Subject Views Written By Posted
Event Scheduler will not start automatically 13050 Ron Calzone 11/20/2010 10:04AM
Re: Event Scheduler will not start automatically 5162 Barry Galbraith 11/20/2010 09:18PM
Re: Event Scheduler will not start automatically 5027 Ron Calzone 11/24/2010 08:46AM
Re: Event Scheduler will not start automatically 3608 Ron Calzone 11/25/2010 11:09PM
Re: Event Scheduler will not start automatically 3905 Ade Haryo Kusumo 11/26/2010 03:48AM
Re: Event Scheduler will not start automatically 3329 Devart Team 11/26/2010 09:45AM
Re: Event Scheduler will not start automatically 3037 Ade Haryo Kusumo 11/26/2010 11:45AM
Re: Event Scheduler will not start automatically 2889 Simon Sellick 12/06/2010 11:31AM
Re: Event Scheduler will not start automatically 2983 Ade Haryo Kusumo 12/07/2010 11:06PM


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.