Event Scheduler pada MySQL Server

Event Scheduler

SHOW VARIABLES LIKE 'event_scheduler';
SET GLOBAL event_scheduler = ON; or SET GLOBAL event_scheduler = 1;
SET GLOBAL event_scheduler = OFF; or SET GLOBAL event_scheduler = 0;

mysql> SHOW VARIABLES LIKE 'event_scheduler';
#mysql -uroot -pxxx --execute='SHOW VARIABLES LIKE "event_scheduler"'

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | OFF   |
+-----------------+-------+