I have created an event to run a simple update query. It was copied and pasted and tested so I know the syntax is correct for the execution body of the event. However, it is still not completing the scheduled task.
The creation code is:
CREATE DEFINER=`xxxxxxxxxxxx`@`%` EVENT `myevent` ON SCHEDULE EVERY 1 SECOND STARTS '2016-10-02 05:15:09' ON COMPLETION PRESERVE ENABLE COMMENT '' DO UPDATE xxxxxxxxx.StatsMaintained SET Value=Value+1 WHERE Value>0
Any idea as to why this occurs with no errors whatsoever? Am I not understanding how an event should be used?