MySQL Forums
Forum List  »  Events (Job Scheduler)

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

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;

Sachin Vyas.

Options: ReplyQuote

Written By
Is it OK to Update table?
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.