首先在sql中查詢計劃事件的狀态:
SHOW VARIABLES LIKE ‘event_scheduler’
如果傳回的是off表示目前是關閉狀态,如果是on目前已經開啟了計劃任務。
采用腳本的方式來實作:
mysql event_scheduler
開啟event_scheduler sql指令:
SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = ;
SET @@global.event_scheduler = ;
相反,關閉event_scheduler指令:
SET GLOBAL event_scheduler = OFF;
SET @@global.event_scheduler = OFF;
SET GLOBAL event_scheduler = ;
SET @@global.event_scheduler = ;