Contact us

Madeira Data Solutions

Your Data, Our Solutions

Why is the job duration a negative number?

Written By: Rotem Medan 02/12/2017

About a month ago I noticed, on one of our clients’ server, a weird duration time for one of the jobs – the job duration was negative.

As it turned out, this could happen due to daylight saving time.

The job started at 01:15, we then changed the clock back to 01:00 at 02:00 and the job finished after about an hour. From SQL Server’s point of view the job’s start time was after the job’s end time which caused an issue for the duration calculation.



Leave a Reply

Your email address will not be published. Required fields are marked *