RE: dbms_scheduler_job_run_details Question
Date: Tue, 25 Jan 2022 16:25:34 -0500
Message-ID: <0ce201d81232$1723b330$456b1990$_at_rsiz.com>
forgive my rust, this could be completely wrong:
Check the OS date of the log file.
Does the time at GMT plus the duration of the job run add up to the log_date?
Does that make it easier to find (or verify deleted) of this particular log at the OS level?
Since it is so seductively close to an exact hour, could it be that the job is an auto-rescheduled job that was created during daylight savings time?
I'm too lazy to look up the description of the meaning of the log_date as documented for that view. My very rusty view is that is the OS time of the last write to that log.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Scott Canaan
Sent: Tuesday, January 25, 2022 3:44 PM
To: 'oracle-l_at_freelists.org'
Subject: dbms_scheduler_job_run_details Question
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 25 2022 - 22:25:34 CET