MySQL Forums
Forum List  »  Events (Job Scheduler)

Is it OK to Update mysql.events table?
Posted by: Sachin Vyas
Date: August 20, 2014 12:30AM

Hello,
I am using MySQL 5.6, have the following 2 queries:
1) Is it OK to update the mysql.last_executed column?

I have to do this because if due to dome reason the event does not execute at the scheduled time, this event internally calls a procedure, so I will call this procedure externally, but I need to update the mysql.last_executed with current date time.

2) Is there a way to call an event manually
i.e. CALL myEvent;


Regards,
Sachin Vyas.

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it OK to Update mysql.events table?
2158
August 20, 2014 12: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.