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
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.