DELIMITER $$
CREATE EVENT IF NOT EXISTS e_order_report_task
ON SCHEDULE
every 1 day
ON COMPLETION PRESERVE
DO BEGIN
CALL p_order_report_task();
END
事件开启与关闭:
开启某事件:ALTER EVENT e_test ON COMPLETION PRESERVE ENABLE;
关闭某事件:ALTER EVENT e_test ON COMPLETION PRESERVE DISABLE;
查询本库所有 任务 select * from information_schema.events
查看 任务是否开启 SHOW VARIABLES LIKE 'event_scheduler';