数据库定时任务执行设置

mysql数据库定时任务每月执行一次
1、show variables like ‘%sche%’; 查看event是否开启OFF关闭ON开启
2、set global event_scheduler =1; 如果关闭，开启event
3、一个月执行一次
create event e_delete_replacement on schedule every 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 0 HOUR)
ON COMPLETION PRESERVE
ENABLE do DELETE from t_data_replacement;
4、查看任务
show events
5、开启
alter event e_delete_replacement on completion preserve enable;
6、关闭
alter event e_delete_replacement on completion preserve disable;
7、删除
drop event if exists e_delete_replacement;