I created an MySql event a few days ago. I don't think it has run. If I do SHOW EVENTS It started on 2015-09-07 00:00:00 and it has an interval of WEEK. Today is 2015-09-14 and it is well after midnight. It has a status of ENABLED. How do I know a) when it last ran, b) what it is supposed to do.
I created an SP which it was supposed to run. I tested this at the time but there is not sign that the SP has been run.
Is there any easy way to debug this? Or even a hard way?!
This information is available through events in INFORMATION_SCHEMA. See LAST_EXECUTED column:
SELECT * FROM INFORMATION_SCHEMA.events;
You can also use SHOW CREATE EVENT yourevent to see what it does.