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

5.40. Evento ba_contratocomodato_mes

 
Nombre del evento:
event_mensual_ba_contratoscomodato_mes
Tiempo de ejecución:
Ultimo dia del mes, a las 23:58 horas.
Tabla involucrada:
Declaracion SQL:
CREATE EVENT `event_mensual_ba_contratoscomodato_mes` 
ON SCHEDULE 
EVERY 1 DAY 
STARTS '2021-10-06 23:58:00' 
ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Creación de tabla mensual ba_contratoscomodato_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_contratoscomodato_mes();                                                                                                                                                         
END IF;                                                                                                                                                                                     
END IF;                                                                                                                                                                                     
END IF;                                                                                                                                                                                     
END
Procedimiento involucrado: