MySQL Forums
Forum List  »  Events (Job Scheduler)

Can an event run again if it is already running?
Posted by: Glenn Schworak
Date: April 21, 2012 04:00PM

I have started working with events and until now they have all been daily clean-up events that don't take long to run.

I have an idea for a new event that I want to run every 10 minutes (or so). But the catch is, in some cases (not often) the run time on the event can take well over 10 minutes and it has a high processor load.

If I schedule this event to run every 10 minutes (for example) and it is alreay running, will I end up with two copies of the event running and hammer my processor? or will the scheduler see that the event is still running from the last time and skip execution?

If it will just fire off another copy of the event, how can I prevent this?

Options: ReplyQuote

Written By
Can an event run again if it is already running?
April 21, 2012 04:00PM

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.