Bug #46813 Anacron-like event scheduler
Submitted: 19 Aug 2009 17:21 Modified: 21 Aug 2009 7:24
Reporter: Chris Hennick Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[19 Aug 2009 17:21] Chris Hennick
The event scheduler should be able to periodically check for, and catch up on, missed events. While events that need to run this way can be scheduled using Task Scheduler on Windows and anacron on Mac and *nix, this is inelegant and platform-dependent.

How to repeat:
Schedule a task to run nightly at midnight, shut down the server at 23:30, and turn it on again at 00:30.
[20 Aug 2009 14:21] Susanne Ebrecht
You mean someting like internal cron job?
[20 Aug 2009 14:51] Chris Hennick
Yes, that's exactly what I mean. A missed event would be caught when the server came back online or became free. Ideally, I'd be able to choose whether an event missed more than once should happen once or as many times as it had been missed.
[21 Aug 2009 7:24] Susanne Ebrecht
Many thanks for writing a reasonable feature request.