MYSQL 定時任務

標籤：

設定定時任務時，首先將event_scheduler設定為1，以開啟事件計劃功能。

1.開啟功能
----------------------------------------
執行命令
set global event_scheduler=1;
select @@event_scheduler;
----------------------------------------
OR
---------------------------------------------------------------
修改檔案
my.ini
# Set the event scheduler. 0 for OFF, 1 for ON.
event_scheduler=1
啟動服務
---------------------------------------------------------------

2.建立計劃
---------------------------------------------------------
CREATE DEFINER=`root`@`%`
EVENT `NewEvent`
ON SCHEDULE EVERY 1 DAY STARTS ‘2015-01-06 17:05:00‘
ON COMPLETION NOT PRESERVE
ENABLE
DO
BEGIN
call Auto_Create_Partition(‘test‘,‘job‘);
call Auto_Create_Partition(‘test‘,‘page‘);
END;
----------------------------------------------------------

MYSQL 定時任務