MySQL Forums
Forum List  »  Events (Job Scheduler)

EVENT not running HELP
Posted by: Darren White
Date: October 19, 2012 05:02AM

I have used an event with event_scheduler many times not problem.....has been deactivated a while.....I now try start it and nothing is happening! Could be I have a new server version since I last tested it.

Server 5.5.28



set global event_scheduler=1;

DELIMITER $$

USE `ddd`$$
CREATE EVENT logging
ON SCHEDULE
EVERY 1 SECOND
STARTS (NOW() + INTERVAL 1 SECOND) -- enter sampling period here
DO
BEGIN

-- start streamers 1-24
INSERT INTO `ddd`.`log_streamer_01` (streamer_tension, cable_speed, reel_speed_rpm, meter_out, synchro_delta_deviation, time)
SELECT streamer_tension, cable_speed, reel_speed_rpm, meter_out, synchro_delta_deviation, NOW()
FROM `ddd`.`b04_reel_data` WHERE id=1;

Options: ReplyQuote


Subject
Views
Written By
Posted
EVENT not running HELP
3858
October 19, 2012 05:02AM


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.