Monitoring SQL Server Agent job run times
- by okeofs
Introduction
A few months back, I was
asked how long a particular nightly process took to run. It was a super
question and the one thing that struck me was that there were a plethora of
factors affecting the processing time. This said, I developed a query to
ascertain process run times, the average nightly run times and applied some
KPI’s to the…