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