MySQL timed task

See if the event is open: Show variables like '%sche% ';
To open the event plan: set global event_scheduler=1;
Shutdown Event Task: Alter event e_test on completion PRESERVE DISABLE;
Account opening event task: Alter event e_test on completion PRESERVE ENABLE;

Create a stored procedure test
CREATE PROCEDURE Test ()
BEGIN
INSERT into table (end_time) VALUES (now ());
END;

Create Event E_test
CREATE EVENT if not exists e_test
On schedule every second
On completion Preserve
Do call Test ();

The stored procedure test is executed every 30 seconds

Scheduled execution of stored procedures on a daily basis starting June 8: On SCHEDULE at TIMESTAMP ' 2016-06-08 12:00:00 '

MySQL timed task