5.34. Evento ba_contratocomodato_balance_mes
Nombre del evento:
|
event_mensual_ba_contratocomodato_balance_mes
|
Tiempo de ejecución:
|
Ultimo dia del mes, a las 23:00 horas.
|
Tabla involucrada:
|
|
Declaracion SQL:
|
CREATE EVENT `event_mensual_ba_contratocomodato_balance_mes`
ON SCHEDULE EVERY 1 DAY STARTS '2021-10-22 23:00:00'
ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Creación de tabla diara ba_contratocomodato_balance_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 = 00
THEN
CALL SP_ba_contratocomodato_balance_mes();
END
IF;
END
IF;
END
IF;
END
|
Procedimiento involucrado:
|
|