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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.