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