sql - MYSQL Create Event Syntax

Question

I am trying to find the syntax to execute a stored procedure once a day around 11pm. This is what I current have:

CREATE EVENT e_call_myproc
    ON SCHEDULE
      EVERY 1 DAY
    DO CALL upd_override("202006", "MH");

How to I specify the time to execute?

Answer 1

you have to make a scheduled event like so : STARTS and ENDS are optional

CREATE EVENT e_call_myproc
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_TIMESTAMP
ENDS [enddate]