首页 > 代码库 > MySQL作业

MySQL作业

创建作业事件

CREATE DEFINER=`root`@`%` EVENT `e_move_loginLog` ON SCHEDULE EVERY 1 MONTH STARTS 2015-01-01 05:30:01 ON COMPLETION NOT PRESERVE ENABLE DO CALL sp_moveLoginRecord()

 

创建作业事件

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

 

查看event是否开启: show variables like %sche%; 将事件计划开启: set global event_scheduler=1; 关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE; 开户事件任务: alter event e_test ON COMPLETION PRESERVE ENABLE; 

 

MySQL作业