MySQL Forums
Forum List  »  Events (Job Scheduler)

MySQL Daily Event Scheduler not working
Posted by: Ganesh Premanath
Date: September 02, 2014 03:36AM

delimiter |

CREATE EVENT event1
ON SCHEDULE
EVERY 1 DAY
STARTS '2014-09-02 12:00:00'
ON COMPLETION PRESERVE

DO

BEGIN
INSERT INTO test(test) VALUES('Prem');
END$$


delimiter ;

I created the event which will run on every day 12 PM.

It works fine for the first time.After that I changed the system's date to

'2014-09-03' and check that event is not working.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Daily Event Scheduler not working
2293
September 02, 2014 03:36AM


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.