MySQL Forums
Forum List  »  Events (Job Scheduler)

Events are created disabled and they never run
Posted by: Manal Helal
Date: September 08, 2016 07:30AM

Hi,

I am using the normal syntax to create an event, but they are created disabled and they never run:

create event p1 on schedule at now() on completion preserve enable do call proc1();


I added enable although it is default to solve this problem, but no good as well, and I need to preserve the event such that I can find it show events / select * from information_scheme.events;

I appreciate your help very much with any privileges required, configuration, or syntax to solve this problem,

thank you,

Manal

Options: ReplyQuote


Subject
Views
Written By
Posted
Events are created disabled and they never run
763
September 08, 2016 07:30AM


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.