List SQL Job duration
If you need step details, see http://www.cookingsql.com/2017/02/duration-of-sql-jobs-steps/
/* DESCRIPTION List duration of jobs CONFIGURATION none some filtering might be used Compatibility List SQL 2008 and up */ select j.name as 'JobName', msdb.dbo.agent_datetime(run_date, run_time) as 'RunDateTime', ((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60) as 'RunDurationMinutes' From msdb.dbo.sysjobs j INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id = h.job_id where 1=1 and j.enabled = 1 --Only Enabled Jobs and h.step_id = 0 --Only show the total duration and j.name like '%backup%' --Uncomment to search for a single job /* and msdb.dbo.agent_datetime(run_date, run_time) BETWEEN '01/01/2017' and '02/01/2017' --Uncomment for date range queries */ order by JobName, RunDateTime desc