CODEWITHSUNDEEP
mysqlmysql-event
user3286430
user3286430

Reputation:

Schedule mysql event to run every chosen day of the week

i want to read my table logs after rotating my logs using an event and i want my event to run in any day of the week i choose.

After doing some research,i have come up with this

CREATE EVENT read_rotated_logs
ON SCHEDULE
  EVERY 1 WEEK
  STARTS CURRENT_DATE + INTERVAL 7 - WEEKDAY(CURRENT_DATE) DAY
    DO BEGIN

    END */$$
DELIMITER ;

Its not clear how i might arrive at a specific day of the week for example monday.How may i structure my code to make the event run on any speific day of the week (mon or tuesday or wednesday or thursday or friday or saturday or sunday)

Upvotes: 2

Views: 4931

Answers (1)

catalinetu
catalinetu

Reputation: 660

Here is how you do it for the other days of the week

Monday

STARTS CURRENT_DATE + INTERVAL 0 - WEEKDAY(CURRENT_DATE) DAY

Tuesday

STARTS CURRENT_DATE + INTERVAL 1 - WEEKDAY(CURRENT_DATE) DAY

and so on

Upvotes: 4

Related Questions