Determining Average Job Runtime

Last Post 28 Feb 2011 06:42 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
phsatech
New Member
New Member

--
27 Feb 2011 06: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
rm
New Member
New Member

--
28 Feb 2011 06:42 AM
msdb..sysjobhistory has run_duration column, can avg it.
You are not authorized to post a reply.

Acceptable Use Policy