JOBRUNNINGLOG的创建-计算程序运行时间-自建JOB监控日志

———–计算程序运行时间–AUTHOR：西安-KK———
DECLARE
time_before BINARY_INTEGER;
time_after BINARY_INTEGER;
time_begintime date;
time_endtime date;
BEGIN
time_before := DBMS_UTILITY.GET_TIME;
time_begintime := sysdate;
DBMS_OUTPUT.PUT_LINE(to_char(time_begintime,’yyyy-mm-dd hh24:mi:ss’));
begin
pac_shujuzlfx_null_wyx_jlzs.P_SHUJUZL_JILUZS_UPDATE;
end;
time_after := DBMS_UTILITY.GET_TIME;
time_endtime:= sysdate;
DBMS_OUTPUT.PUT_LINE(to_char(time_endtime,’yyyy-mm-dd hh24:mi:ss’));
DBMS_OUTPUT.PUT_LINE (‘已完成,耗时’||round((time_after – time_before)/100,4)||’秒’);
END;