Mysql Event to run on every sunday every 1 hour

Question

I'm to new to mysql event scheduling and want to schedule a task which should run on every sunday internal of 1 hour.

Can any one help with this ?

CREATE EVENT event_forEverysundayeveryhour
ON SCHEDULE EVERY 1 Week
STARTS CURRENT_DATE + INTERVAL (6 - WEEKDAY(CURRENT_DATE)) DAY
ON COMPLETION PRESERVE
DO Begin

End;

Hasan Raza · Answer 1 · 2023-07-21T10:57:10.600

0

DELIMITER $$

CREATE EVENT event_forEverysundayeveryhour
ON SCHEDULE EVERY 1 WEEK
STARTS CURRENT_DATE + INTERVAL (6 - WEEKDAY(CURRENT_DATE)) DAY + INTERVAL 1 HOUR -- Starts on the next Sunday at 1 AM
ON COMPLETION PRESERVE
DO
BEGIN
  -- Your event logic here
END $$

DELIMITER ;

edited Jul 21 '23 at 10:57

answered Jul 21 '23 at 08:54

Hasan Raza

424
3
9

Thank for the answer Hasan raza but this will going to run only for single week. I want scheduler to run every week on sunday for every hour – LATIF CHAUDHARY Jul 21 '23 at 10:42
try this one as per your requirements – Hasan Raza Jul 21 '23 at 10:57

Mysql Event to run on every sunday every 1 hour

1 Answers1