1.创建job
每天的凌晨0点10分执行指定的procedure pro_test:CREATE EVENT `event_test` ON SCHEDULE EVERY 1 DAY STARTS '2013-10-15 00:10:00'
每天的凌晨0点10分执行指定的procedure pro_test:CREATE EVENT `event_test` ON SCHEDULE EVERY 1 DAY STARTS '2013-10-15 00:10:00'
ON COMPLETION NOT PRESERVE ENABLE
DO CALL pro_test();
2. 删除job: drop event event_test;
3. 查看当前库下所有的 job: show events;
4.查看job是否开启了自动执行
show global variables like '%event_scheduler%';
5.开启job自动执行:set global event_scheduler = on;
6. MYSQL相关的配置参数
在 /etc/my.cnf下面添加:
event_scheduler = 1
mysql server重启之后会将 global event_scheduler 设置为 on
要是没有 重启之后 就是off.