Event Scheduling not Running in Mysql Server ?

Question

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