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: Ade Haryo Kusumo ()
Date: November 26, 2010 03:48AM

Hi..

I'm new to mySQL and want to use this Event Scheduler.

My goal is i want to update my table automatically every day at 00.00 AM. here is my syntax:

Create Event UpdateStatus
On Schedule every 1 day
Starts '2010-11-25 00:00:00'
On Completion Preserve
Do update Coupons set coupon_status ='Expired' where Coupon_exp_date = Curdate();

But when the time reach 00.00 AM, my table didn't change.. is there something wrong in my script?

Thanks,
Ade.

Options: ReplyQuote


Subject Views Written By Posted
Event Scheduler will not start automatically 12272 Ron Calzone 11/20/2010 10:04AM
Re: Event Scheduler will not start automatically 4817 Barry Galbraith 11/20/2010 09:18PM
Re: Event Scheduler will not start automatically 4782 Ron Calzone 11/24/2010 08:46AM
Re: Event Scheduler will not start automatically 3402 Ron Calzone 11/25/2010 11:09PM
Re: Event Scheduler will not start automatically 3684 Ade Haryo Kusumo 11/26/2010 03:48AM
Re: Event Scheduler will not start automatically 3129 Devart Team 11/26/2010 09:45AM
Re: Event Scheduler will not start automatically 2860 Ade Haryo Kusumo 11/26/2010 11:45AM
Re: Event Scheduler will not start automatically 2711 Simon Sellick 12/06/2010 11:31AM
Re: Event Scheduler will not start automatically 2825 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.