MYSQL定时调度执行SQL语句

1.检查事件计划是否开启

show  variables like '%sche%';

2.将事件计划开启

set global event_scheduler=1;

3.开启/关闭定时事件

alter event e_toemptarget ON COMPLETION PRESERVE DISABLE;

alter event e_toemptarget ON COMPLETION PRESERVE ENABLE;

4.新建存储过程toemptarget

begin

-- 预算与实际支出执行效率
INSERT INTO emp_target(mail_name, tag_id, tag_value, units,compute_date )
SELECT mail_name, "0804", budget_spend_efficiency, "",SUBSTR(CURRENT_DATE(),1,7)
FROM work_efficiency;

end;

5.新建事件e_toemptarget每天定时调存储过程

call toemptarget();