MySQL Forums
Forum List  »  MySQL Workbench

While using event scheduler in mysql it's working only one time
Posted by: Jen P
Date: November 28, 2016 10:58PM

I am using mysql workbench6.3.7. I used event scheduler to execute the query everyday morning 9 o'clock I have used the following query

delimiter $$
create event eventtable
on schedule every '1' day
starts '2016-11-25 16:00:00'
do
begin
<statement>
end;
$$;

but it's working only one day it's not working daily.What am I missing??.Should i have to execute the query daily? Should I have to on the global scheduler daily? Please help me with this.
Thank you,
Jen

Options: ReplyQuote


Subject
Views
Written By
Posted
While using event scheduler in mysql it's working only one time
1328
November 28, 2016 10:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.