MYSQL任务 常用命令

#通过下列语句查询event是否开启
show variables like '%sche%';

#通过执行下列语句，来开启event_scheduler
set global event_scheduler =1;

-- 开启事件

ALTER EVENT data_serv_apply_summary_event ON

COMPLETION PRESERVE ENABLE;



-- 关闭事件

ALTER EVENT data_serv_apply_summary_event ON

COMPLETION PRESERVE DISABLE;