In order to have MySQL event run, we need to make sure GLOBAL event_scheduler is set to on or 1.
SET GLOBAL event_scheduler = ON;
Or we can set in my.ini (in windows) or my.cnf (in linux) file with value
event_scheduler=on
Then create a scheduler job in MySQL. Example, i wish to call a stored procedure psp_DailyJob() every day start from 12:25:00.
CREATE EVENT CallDailyJob
ON SCHEDULE EVERY 1 DAY STARTS '2011-07-18 12:45:00'
DO
CALL psp_DailyJob()
No comments:
Post a Comment