建立存储过程，我们设置定时任务，在mysql 里面应该如何设置呢？

第一种，每天凌晨1点执行

DROP PROCEDURE IF EXISTS alarm_consumer_off;  
DELIMITER $$
    create PROCEDURE alarm_consumer_off()
    BEGIN
		update alarm_consumer_off set is_enable='N' WHERE `group`='dws_tags_offline' and topic='dwd-byt-data';
		
end  $$

delimiter;


# 每天凌晨1点开始执行

create event alarm_consumer_off_event on schedule  EVERY 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 1 HOUR)

ON COMPLETION PRESERVE ENABLE  do call alarm_consumer_off()



DROP PROCEDURE IF EXISTS alarm_consumer_on;  
DELIMITER $$
    create PROCEDURE alarm_consumer_on()
    BEGIN
		update alarm_consumer_off set is_enable='Y' WHERE `group`='dws_tags_offline' and topic='dwd-byt-data';
		
end  $$

delimiter;


# 每天凌晨2点开始执行

create event alarm_consumer_on_event on schedule  EVERY 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 2 HOUR)

ON COMPLETION PRESERVE ENABLE  do call alarm_consumer_on()

第二种：间隔每小时执行 ，或者间隔每分钟级别执行

create event dynamic_temp_param_event on schedule every 1 HOUR  do call dynamic_temperature()


create event dynamic_temp_param_event on schedule every 1 MINUTE  do call dynamic_temperature()