• Eitan Blumin

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

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

JOIN OUR MAILING LIST

 +972-9-7400101

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