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