MySQL Forums
Forum List  »  Events (Job Scheduler)

events not working
Posted by: Jiang Zhao
Date: March 06, 2009 09:44AM

Hello All

I have a problem with event(not working).
mysql version is 5.1.31
operating system is SUSE 10 LINUX.
my code is as below.

DELIMITER $$
DROP EVENT IF EXISTS clsSession $$
CREATE EVENT clsSession
ON SCHEDULE EVERY 1 MINUTE STARTS '2009-03-04 10:25:58'
DO
BEGIN
insert into emp_count select count(*) from emps;
END $$

I have confirmed in mysql. it like that
mysql> select starts, execute_at, time_zone, event_name, status from information_schema.events; +---------------------+------------+-----------+------------+---------+
| starts | execute_at | time_zone | event_name | status |
+---------------------+------------+-----------+------------+---------+
| 2009-03-04 10:25:58 | NULL | SYSTEM | clsSession | ENABLED |
+---------------------+------------+-----------+------------+---------+
1 row in set (0.00 sec)

time zone is local time.

Options: ReplyQuote


Subject
Views
Written By
Posted
8416
February 28, 2006 05:30AM
6071
March 03, 2006 06:34PM
events not working
9421
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.