aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_log_endday
Parameters
Name
Type
Mode
msg
text
IN
Definition
BEGIN RAISE NOTICE '%', msg; --PERFORM sp_prop_query(NULL, format('select sp_log_info(%L, %L, %L)', 'endday', msg, 'I')); -- BEGIN; PERFORM sp_prop_exec(null, format('INSERT INTO sys_log(log_tag, log_msg, log_level) VALUES (%L, %L, %L)', 'endday', msg, 'I')); -- INSERT INTO sys_log(log_tag, log_msg, log_level) VALUES ('endday', msg, 'I'); -- --PERFORM sp_log_info('endday', msg); -- COMMIT; END