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.