jobs history | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

jobs history

hi do any body know how to get Avg execution and maximum execution time for all jobs ??
thank you
You mean maitenance jobs, etc.?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
By running sp_help_jobhistory you will get the job history details where you can asess for yourself. _________
Satya SKJ

select,Average=avg(run_duration),Maximum=max(run_duration) from sysjobs a
inner join sysjobhistory b
on a.job_id=b.job_id
group by
NewDBA, avg(run_duration) will give avg run duration for all steps……as sysjobhistory has timings for all steps per job….
I just want avg of tatal job timings… I right?? thank you