查看调度器状态
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();