MySQL Forums
Forum List  »  Events (Job Scheduler)

Error creating scheduled event in 5.1.28 & 5.1.29 with interval
Posted by: Eyal Sorek
Date: October 31, 2008 04:24AM

Hi,

I tried to create event at certain time and failed on both 5.1.28-rc-community & 5.1.29-rc-community versions on linux centos.

A simple test case that works:
CREATE EVENT `test_event`
ON SCHEDULE
EVERY 1 HOUR
DO select now();

A simple test case that fails:
CREATE EVENT `test_event`
ON SCHEDULE AT current_timestamp + INTERVAL 1 HOUR
EVERY 1 HOUR
DO select now();

or even this basic test fails:
CREATE EVENT `test_event`
ON SCHEDULE AT current_timestamp
EVERY 1 HOUR
DO select now();

It looks like a bug with combination of specific scheduling time + every interval.
Since without mentioning AT <timestamp> after ON SCHEDULE it works with every clause, but when mentioning specific timestamp after ON SCHEDULE it does not work.

I wanted to add few events on rounded times (every rounded hour, or rounded half and hour etc..

In addition also --> SHOW SCHEDULER STATUS fails with syntax error...

Thanks,
Eyal Sorek

Options: ReplyQuote


Subject
Views
Written By
Posted
Error creating scheduled event in 5.1.28 & 5.1.29 with interval
4902
October 31, 2008 04:24AM


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.