mysql - MsSql 计划触发的事件

Question

我已经注册了一个事件调度程序，每周一运行，并完成了谷歌搜索要求遵循的所有步骤。 。我已将服务器日期回溯到星期一日期。但该事件仍然没有被触发。

第 1 步设置均匀调度程序:

SET GLOBAL event_scheduler = ON;

第 2 步创建事件:

CREATE EVENT ScheduledFaMeetingTableUpdate
ON SCHEDULE
  EVERY 1 WEEK
  STARTS CURRENT_DATE + INTERVAL 0 - WEEKDAY(CURRENT_DATE) DAY + INTERVAL 10 HOUR
    DO 
    Call FAMeetingWeekUpdate_sp();

SELECT @@global.event_scheduler; 
Result : ON

Show Events;
Result :
'bitnami_redmine', 'ScheduledFaMeetingTableUpdate', 'root@localhost', 'SYSTEM', 'RECURRING', NULL, '1', 'WEEK', '2017-08-14 10:00:00', NULL, 'ENABLED', '0', 'utf8', 'utf8_general_ci', 'utf8_general_ci'


SHOW PROCESSLIST;
Result :
'1', 'event_scheduler', 'localhost', NULL, 'Daemon', '-65135', 'Waiting for next activation', NULL

Answer 1

您尚未指定该事件应一次又一次执行。

来自manual :

Normally, once an event has expired, it is immediately dropped. You can override this behavior by specifying ON COMPLETION PRESERVE. Using ON COMPLETION NOT PRESERVE merely makes the default nonpersistent behavior explicit.

您的创建事件语句应如下所示:

CREATE EVENT ScheduledFaMeetingTableUpdate
ON SCHEDULE
EVERY 1 WEEK
STARTS CURRENT_DATE + INTERVAL 0 - WEEKDAY(CURRENT_DATE) DAY + INTERVAL 10 HOUR
ON COMPLETION PRESERVE
DO 
    Call FAMeetingWeekUpdate_sp();