SQL Server Monthly Job Run Time Averages

Sometime as a ETL developer or Database Administrator you will need to gain insight into SQL Agent job executions times. This insight can be used to proactively monitor the processing times of the various jobs running within your data environment.

Information about jobs execution times is stored in the MSDB database in table sysjobhistory. This table has the start time and the run duration times which I have used to create a report that will show the average job start and end times by month for all jobs running on a instance of SQL Server.

Results MonthlyaverageI typically schedule this to run on the first day of the month to help me better understand how the job processing times are trending month over month. I hope you find this code as helpful as I have.

Leave a Reply