Bug #46076 Events are not firing
Submitted: 9 Jul 2009 9:48 Modified: 9 Jul 2009 11:00
Reporter: Chirag Fisher Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.1.35 OS:Windows (SP3)
Assigned to: CPU Architecture:Any
Tags: Events are not firing

[9 Jul 2009 9:48] Chirag Fisher 
Description:
I create a Event as

delimiter |

Create EVENT myevent
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
	BEGIN
		Update eveningmilkingevent
		Set milking = Day(Current_Date)
		Where id = 1;
	END |
delimiter ;

later i edited it

ALTER EVENT myevent
ON SCHEDULE
EVERY 1 minute
STARTS '2009-07-09 15:07:00';

But never got fired

How to repeat:
repeat above steps

Update eveningmilkingevent
Set milking = Day(Current_Date)
Where id = 1;

Updates my table
[9 Jul 2009 9:52] Giuseppe Maxia 
Have you activated the event scheduler?

SET GLOBAL event_scheduler=ON;

Or, is the event scheduler disabled in the options file (my.cnf)?
[9 Jul 2009 10:25] Chirag Fisher 
OOPS
Sorry
Thanks Got that.