MySQL Forums
Forum List  »  Events (Job Scheduler)

One time event never runs?
Posted by: eddy eddy
Date: May 25, 2013 02:02AM

Hi,

Please have a look at below events

1) create EVENT Test1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 20 second ON COMPLETION PRESERVE ENABLE DO ...

2) create EVENT Test2 ON SCHEDULE EVERY 20 SECOND STARTS CURRENT_TIMESTAMP ON COMPLETION PRESERVE ENABLE DO ...

I expect event Test1 to run one time after 20 seconds but it never runs.
Event Test2 is working fine.

What's the problem?
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
One time event never runs?
2921
May 25, 2013 02:02AM


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.