MySQL Forums
Forum List  »  Events (Job Scheduler)

Unable to get events to run
Posted by: Richard
Date: February 21, 2008 05:09PM

Hello all,
I am uable to get an event that runs. Here is what I tried:
MySQL 5.1.22rc on Solaris 10 SPARC. I'm in the MST time zone.
set global event_scheduler=ON;

CREATE TABLE  `test`.`event_test` (
  `thetime` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE EVENT IF NOT EXISTS test.testevent
ON SCHEDULE
EVERY 1 MINUTE
STARTS '2008/02/21 15:52:00'
DISABLE ON SLAVE
DO
insert into test.event_test values(now());



I check the test.event_test table a few minutes after the event was suppose to start and nothing is inserted into the test table. I call this stmnt:
SELECT * FROM mysql.event e;
and the field last_executed is null. The starts field also says 22:52:00. I then drop the event and modify it to:
CREATE EVENT IF NOT EXISTS test.testevent
ON SCHEDULE
EVERY 1 MINUTE
STARTS '2008/02/21 8:52:00'
DISABLE ON SLAVE
DO
insert into test.event_test values(now());
so that the starts field matches the time I expect it to run. This also does not work. Not sure what I am doing wrong.

Any thoughts?
Richard k

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to get events to run
4544
February 21, 2008 05:09PM


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.