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
emps;

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
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with recurring events
8457
February 28, 2006 05:30AM
6107
March 03, 2006 06:34PM
9521
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.