• Madeira Team

Why is the job duration a negative number?

Updated: May 14, 2020

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

0 comments

Recent Posts

See All

STAY IN TOUCH

Get New posts delivered straight to your inbox

Thank you for subscribing!