MySQL定时任务

查看调度器状态

SHOW VARIABLES LIKE 'event_scheduler';
SELECT @@event_scheduler;
SHOW PROCESSLIST;

开启事件调度器 可通过如下任何一个命令行

SET GLOBAL event_scheduler = ON; 
SET @@global.event_scheduler = ON; 
SET GLOBAL event_scheduler = 1; 
SET @@global.event_scheduler = 1; 

本地登陆MySQL

mysql -uroot -p -S/mysql/3306/data/mysql.sock

重启后自动开启事件调度器

只需要在my.ini或者my.cnf配置文件的[mysqld]部分加上event_scheduler=ON 即可

查看当前配置的任务

SELECT EVENT_NAME, LAST_EXECUTED FROM information_schema.EVENTS;

删除任务

drop event work.work_task;

创建任务

create event work.work_task
	on schedule
	every 1 DAY 
	starts  '2020-06-15 00:00:30'
    on COMPLETION PRESERVE
    ENABLE
do call work.sp_task();

更多请参考：

https://www.cnblogs.com/qlqwjy/p/7954175.html