CODEWITHSUNDEEP
mysqlscheduled-tasksmysql-event
LATIF CHAUDHARY
LATIF CHAUDHARY

Reputation: 3

Mysql Event to run on every sunday every 1 hour

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;

Upvotes: 0

Views: 333

Answers (1)

Hasan Raza
Hasan Raza

Reputation: 525

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 ;

Upvotes: 0

Related Questions