Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Check SQL Job timings

By Shishir Tewari, 2012/09/11

Open Management studio. Use msdb database and execute the script. The user should be sysadmin to execute this script.

Use msdb 
go
SELECT name, 
   step_id 
  ,run_date 
  ,count(*) howMany
  ,min((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60) lowest_Min 
  ,avg((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60) average_Min 
  ,max((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60) highest_Min 
  ,stdev((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60) stdev_Min 
 from sysJobHistory h 
inner join sysjobs j  on 
(h.job_id = j.job_id) 
where name =''
group by name, step_id, run_date 
order by run_date desc

Total article views: 1714 | Views in the last 30 days: 0