Hi All ,
I have using Event Scheduler in Mysql server . Its not working . I have changed global Setting to ON .
DELIMITER |
alter DEFINER=`suntoyoroot`@`%` EVENT `BranchCount`
ON SCHEDULE EVERY 1 minute STARTS '2020-03-20 14:15:00' ON COMPLETION PRESERVE ENABLE
COMMENT 'Its Branch Count'
do
IF CURRENT_TIME() BETWEEN '00:00:00' AND '12:00:00' THEN
CALL BranchList();
END IF
|
DELIMITER ;
If anyone know let me know with suggestion with exact code .
Thanks in advance
Karthik K
Vinay SinghPosted Mar 21, 2020, 2:51 AM
Events are run by the scheduler, which is not started by default. Using
SHOW PROCESSLISTis possible to check whether it is started. If not, run the commandto run it.