MySQL Forums
Forum List  »  Events (Job Scheduler)

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

Written By
Re: Event Scheduler will not start automatically
December 06, 2010 11:31AM

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.