How to check event scheduler status mysql

mysql events scheduler
GorvGoyl picture GorvGoyl · Aug 26, 2016 · Viewed 44.1k times · Source

In MySQL, we can enable the event scheduler by following query:

SET GLOBAL event_scheduler = ON;

Similarly, to turn off the scheduler:

SET GLOBAL event_scheduler = OFF;

But, Is there any query/way to check the status of this event_scheduler whether it's on or off?

Answer

mnv picture mnv · Aug 26, 2016

Use SHOW VARIABLES

SHOW VARIABLES
WHERE VARIABLE_NAME = 'event_scheduler'

Related questions

MySQL Event Scheduler on a specific time everyday

Here's my query CREATE EVENT RESET ON SCHEDULE AT TIMESTAMP DO UPDATE `ndic`.`students` SET `status` = '0'; How can I update status to "0" at 1 pm every day. What can I use instead of TIMESTAMP?

Read More
How to set global event_scheduler=ON even if MySQL is restarted?

I want to set the event_scheduler global to ON even if MySQL is restarted; how can I achieve this? SET GLOBAL event_scheduler = ON;

Read More
Can I set a MySQL event schedule using phpMyAdmin?

I want to increment a field on the first minute of every day, and then once it hits a certain value, set the value to 1. I would like to do this directly in MySQL, but preferably through phpMyAdmin. I am …

Read More