Determining Average Job Runtime

Last Post 28 Feb 2011 05:42 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Feb 2011 05:41 PM
Hi there:

I'm looking to find the average run time of a job that runs mutiple times daily. We have two columns that contain job start and end times. BEGINDTTM (begin time of job) and ENDDTTM (end time of job). I'd usually query the job, using something like SELECT * FROM JOBS WHERE process= 'Crystal_ReportA' AND BEGINDTTM = '2011-02-24'. I believe I can use a @AVG operator but not sure the best way to setup this up.

Appreciate responses
New Member
New Member

28 Feb 2011 05:42 AM
msdb..sysjobhistory has run_duration column, can avg it.

Acceptable Use Policy