Troubleshooting a MySQL Event Scheduler

[aaron4osu]

I’m trying to create a MySQL Event Scheduler to refresh a value in my table every day at a specific time. Lets say 1am.

I can’t seem to get it to work.

Here is what I have thus far:

DROP EVENT IF EXISTS resetRoster;

CREATE EVENT resetRoster
ON SCHEDULE EVERY ‘1’ DAY
STARTS ‘2016-06-24 01:00:00’
DO
UPDATE memberRoster SET status=‘Select Status’

[TheRedDevil]

Have you changed the settings on the MySQL server and turned the Event Scheduler on? It is turned off by default.