MySQL Event Scheduler run 10 times per day

Question

I want to run a query statement 10 times per day. I know I should use event scheduler like

CREATE EVENT event_name
  ON SCHEULE
    EVERY 1 DAY
    STARTS (TIMESTAMP(CURRENT_DATE) + INTERVAL 1 DAY + INTERVAL 1 HOUR)
  DO
    # Your query

But How can I run it 10 times per day? Thx

http://stackoverflow.com/questions/3070277/mysql-event-scheduler-on-a-specific-time-everyday — Sathish D, May 05 '14 at 11:41

Tirthrajsinh Parmar · Accepted Answer · 2014-05-05T12:29:47.697

2

CREATE EVENT event_name
  ON SCHEDULE
    EVERY 144 MINUTE
    STARTS (TIMESTAMP(CURRENT_DATE) + INTERVAL 1 DAY + INTERVAL 1 HOUR)
  DO
    # Your query

for 10 times in a day you can set like this means (24/10)=2.4 & (2.4*60)=144 minutes so it will execute 10 times in a day

edited May 05 '14 at 12:29

answered May 05 '14 at 11:41

Tirthrajsinh Parmar

158
1
7

MySQL Event Scheduler run 10 times per day

1 Answers1