MySQL Forums
Forum List  »  Events (Job Scheduler)

Problem with recurring events
Posted by: Andrew Gilfrin
Date: February 28, 2006 05:30AM

Hi All,

I'm currently writing some content on the event scheduler but I'm having trouble with recurring events. I use the following to code create the event.

create event e_count
on schedule every 1 minute starts '2006-02-26 21:50:00'
do insert into emp_count select now(), count(*) from

It works fine the first time but I would expect it to then fire every minute after that event but it doesn't. Is it just not working at the moment (I know it doesn't work at all on Windows) or is there something I'm doing wrong?

I'm using 5.1.6-alpha on Mac OS X 10.0.3

Andrew Gilfrin
My MySQL related Blog
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote

Written By
Problem with recurring events
February 28, 2006 05:30AM
March 03, 2006 06:34PM
March 06, 2009 09:44AM

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.