Return
-
Title
Agent log includes DBSS_Agent_Job_List collection failures "Get negative complete duration value -1.0 for job" -
Description
Errors similar to the following are found in the SQL Server agent logs
WARN [AGENTNAME-lowPriorityPool-2-[DBSS_Agent_Job_List][]] com.quest.qsi.fason.sqlserver.collection.processor.DBSSAgentJobListProcessor - Get negative complete duration value -1.0 for job [JOBNAME], skip this record.
-
Cause
CAUSE 1When the job duration is calculated there is a negative time in the duration time. Negative time was a result of the time DST change. All the "negative" time for the other jobs are as well from Nov 1st (same as the original job). the DST clock change in Northern America.CAUSE 2When a job is still running it can also have a negative duration. -
Resolution
WORKAROUND
Rename the job so that it does not use the same job history in msdb.sys.sysjobhistory and reset the collection to calculate the average duration from scratch.RESOLUTIONThis is by design. Enhancement Request SSDB-13216 was added to the 5.7.5.1 and higher SQL Server cartridges to mark the line as false when the Metrics "complete_duration" and "complete_duration" of the collection "Agent Job List" is negative.