You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a few long running jobs (over 6 hours) such as backups that report exactly double or triple the duration. e.g. 8 hour backup reports 16 hours or 24 hours. This is reflected in both reports and seems to effect jobs that cross over the midnight (day) into the next day. I also do not believe I have found a job that runs under an hour that behaves this way. After analyzing the script I'm not exactly sure what it could be.
I really enjoy the matrix report! Great job with it.
SQL 2016 SP1 CU5 on Windows 2016
The text was updated successfully, but these errors were encountered:
daveywave
changed the title
Some agent jobs duration report double duration
Some agent jobs duration report double or triple duration
Feb 28, 2018
I have a few long running jobs (over 6 hours) such as backups that report exactly double or triple the duration. e.g. 8 hour backup reports 16 hours or 24 hours. This is reflected in both reports and seems to effect jobs that cross over the midnight (day) into the next day. I also do not believe I have found a job that runs under an hour that behaves this way. After analyzing the script I'm not exactly sure what it could be.
I really enjoy the matrix report! Great job with it.
SQL 2016 SP1 CU5 on Windows 2016
The text was updated successfully, but these errors were encountered: