SQL Server Performance Forum – Threads Archive
jobs historyhi do any body know how to get Avg execution and maximum execution time for all jobs ??
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.
By running sp_help_jobhistory you will get the job history details where you can asess for yourself. _________
select a.name,Average=avg(run_duration),Maximum=max(run_duration) from sysjobs a
inner join sysjobhistory b
group by a.name
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…..am I right?? thank you