mysql 定时执行存储过程

CREATE DEFINER=`root`@`%` PROCEDURE `pro_user_ucwc_list_decId`()
BEGIN
    set @v_sql = concat("insert into t_alarm_log (devId,cvs,createDate) SELECT @devId:=devid , @cvs:=sum(vcs),curdate() FROM db_cloudCount.`t_user_ucvvc_list_",date_sub(curdate(),interval 1 day),"` group by devId ");
prepare stmt from @v_sql;  #预处理需要执行的动态SQL，其中stmt是一个变量
EXECUTE stmt;      #执行SQL语句
deallocate prepare stmt;
    
    DELETE FROM db_cloudCount.t_alarm_log WHERE CREATEDATE <= DATE_SUB(CURDATE(), INTERVAL 1 MONTH);
    commit;

End

--每天定时2：30运行

CREATE event IF NOT EXISTS user_ucwc_list_decId_event ON SCHEDULE EVERY 1 DAY  
STARTS '2016-07-05 02:30:00' 
ON COMPLETION PRESERVE   
DO CALL pro_user_ucwc_list_decId();

##30秒执行一次

CREATE event IF NOT EXISTS user_ucwc_list_decId_event ON SCHEDULE EVERY 30 second  
ON COMPLETION PRESERVE   
DO CALL pro_user_ucwc_list_decId();