mysql定时任务

一、查看event是否开启

 

show variables like '%sche%';

　　

开启event_scheduler

 

set global event_scheduler =1;

　　

为了重启mysql也能生效，最好再my.ini(linux在my.cnf)里面设置

event_scheduler =1

　　

二、创建存储过程

CREATE PROCEDURE test ()
BEGIN
sql;
END;

三、创建event e_test

create event if not exists e_test
on schedule every 30 second
on completion preserve
do call test();

每隔30秒将执行存储过程test

关闭事件任务

alter event e_test ON COMPLETION PRESERVE DISABLE;

 

开启事件任务

alter event e_test ON COMPLETION PRESERVE ENABLE;