MySQL加入JOB

1 查看定时任务是否开启 

SELECT @@event_scheduler;
SHOW VARIABLES LIKE 'event%';

2 开启方法

set GLOBAL event_scheduler = 1;
SET GLOBAL event_scheduler = ON;

3 创建定时任务

CREATE EVENT RESET_DEFAULT_SET_JOB
ON SCHEDULE EVERY 1 DAY STARTS timestamp(adddate(date(sysdate()),1))     ##这里是设置执行周期，当前设定为每天凌晨12点执行一次，
ON COMPLETION PRESERVE
DO
CALL RESET_DEFAULT_SET_PROCEDURE();
 

4.删除定时任务 

DROP EVENT IF EXISTS RESET_DEFAULT_SET_JOB;

5 查询定时任务

show events;