Mysql Event scheduler

I have already posted a blog "Event Scheduler an alternative to cronjob" with different advantages of Even scheduler over cron job.

Here I am sharing how you can configure MySql server to enable or disable scheduler and writing a sample event scheduler.

You can check with below query as your server is up for event scheduler or not.

SELECT @@event_scheduler;

Query will gives your "ON" or "OFF". if it is off you can enable it as:

SET GLOBAL event_scheduler = ON;

Now you can create your own event scheduler as below:

CREATE EVENT suresh_test
ON SCHEDULE
EVERY 10 SECOND
DO
INSERT INTO test_scheduler (`datetime`) VALUES (CURRENT_TIMESTAMP);

The above scheduler will runs every 10 second and insert a row in "test_scheduler" table.




Your feedbacks are most welcome..