Menu
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?
973
SELECT * FROM INFORMATION_SCHEMA. events; You can also use SHOW CREATE EVENT yourevent to see what it does.
To enable the Event Scheduler, restart the server without the --event-scheduler=DISABLED command-line option, or after removing or commenting out the line containing event-scheduler=DISABLED in the server configuration file, as appropriate.
SET GLOBAL event_scheduler = OFF; SET @@global. event_scheduler = OFF; SET GLOBAL event_scheduler = 0; SET @@global. event_scheduler = 0; but it stops all 5 event Scheduler.
Assuming you have MySQL rights to create events, the basic syntax is: CREATE EVENT `event_name` ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] DO BEGIN -- event body END; The schedule can be assigned various settings, e.g.
Use SHOW VARIABLES
SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler' If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
