Unable to execute the event in mysql

Databases
1

Hi

ALL

I am trying to execute the event every night at 01:05:00

but mysql is not executing the event

Here is the code

CREATE EVENT booking_details_history
ON SCHEDULE EVERY 1 DAY
STARTS ‘2011-02-26 01:05:00’
ON COMPLETION PRESERVE
COMMENT ‘Daily copy of Perious Booking to booking_details_history’
DO CALL booking_details_history();

please help me out, it is urgent

Thanks

MD.Samiuddin

2

You might have written the scheduler in one server and tried to execute it into the other.
Please check the version of the server if that supports scheduling.

Otherwise, may be MySQL documentation helps you.
http://dev.mysql.com/tech-resources/articles/event-feature.html