DOCUMENTACIÓN OXIPRO
Manual de instrucciones - Base de Datos
 
×
Menú
Índice
 

5.35.  Evento ba_pqrs_mes

 
Nombre del evento:
event_mensual_ba_pqrs_mes
Tiempo de ejecución:
Ultimo dia del mes, a las 23:58 horas.
Tabla involucrada:
Declaracion SQL:
CREATE EVENT `event_mensual_ba_pqrs_mes` 
ON SCHEDULE 
EVERY 1 DAY 
STARTS '2021-12-31 23:58:00' 
ON COMPLETION NOT PRESERVE ENABLE
COMMENT 'Creación de tabla mensual SP_ba_pqrs_mes'
DO BEGIN                                        
DECLARE rightnow DATETIME;                                                                                                                                                                  
DECLARE hh,mm TINYINT;                                                                                                                                                                   
SET rightnow = NOW();                                                                                                                                                                       
SET hh = HOUR(rightnow);                                                                                                                                                                    
SET mm = MINUTE(rightnow);                                                                                                                                                                  
                                                                                                                                                                                                IF DATE(rightnow) = LAST_DAY(DATE(rightnow)) THEN                                                                                                              
IF hh = 23 THEN                                                                                                                                                                             
IF mm = 58 THEN                                                                                                                                              
CALL SP_ba_pqrs
mes();                                                                                                                                                                      
END IF;                                                                                                                                                                                     
END IF;                                                                                                                                                                                     
END IF;                                                                                                                                                                                     
END
Procedimiento involucrado: