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
No comments:
Post a Comment