STAY IN TOUCH

Get New posts delivered straight to your inbox

  • Madeira Team

Why is the job duration a negative number?

Updated: May 14

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

JOIN OUR MAILING LIST

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

 +972-9-7400101

  • Google+ - White Circle
  • Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle