MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: to call an event
Posted by: Devart Team
Date: October 14, 2009 01:27AM

Events are executed by a event scheduler. Firstly, you should start this one with a next statement:
SET GLOBAL event_scheduler = 1;

Then, you can create and shedule your event.
For example:
CREATE
DEFINER = 'root'@'localhost'
EVENT test.event1
ON SCHEDULE AT '2010-01-01 00:00:01'
DO
BEGIN
INSERT INTO test.table1 VALUES('work');
END

Find more information on events in 'Event Scheduler' topic of MySQL reference.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
4792
September 03, 2009 04:51AM
Re: to call an event
2750
October 14, 2009 01:27AM


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.