Why is the job duration a negative number?

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.

#job #sqlagent