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
yamaha

---

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
Moderator
SQL-Server-Performance.Com

---

select a.name,Average=avg(run_duration),Maximum=max(run_duration) from sysjobs a
inner join sysjobhistory b
on a.job_id=b.job_id
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
yamaha

---

]]>