Hi,
i configrued a event scheduler to run some sql command. It worked well, but it was unexpectedly stoped. Then i recreated a new event scheduler, but it doesn't work. Why?
*************************** 1. row ***************************
EVENT_CATALOG: def
EVENT_SCHEMA: TEST
EVENT_NAME: Update
DEFINER:
root@mysql1.domain.com
TIME_ZONE: SYSTEM
EVENT_BODY: SQL
EVENT_DEFINITION: UPDATE XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EVENT_TYPE: RECURRING
EXECUTE_AT: NULL
INTERVAL_VALUE: 1
INTERVAL_FIELD: DAY
SQL_MODE:
STARTS: 2016-06-26 00:07:00
ENDS: NULL
STATUS: ENABLED
ON_COMPLETION: NOT PRESERVE
CREATED: 2016-06-25 14:50:25
LAST_ALTERED: 2016-06-25 14:50:25
LAST_EXECUTED: 2016-07-12 00:07:00
EVENT_COMMENT:
ORIGINATOR: 0
CHARACTER_SET_CLIENT: utf8
COLLATION_CONNECTION: utf8_general_ci
DATABASE_COLLATION: utf8_general_ci
1 row in set (0.00 sec)