rk1980factor (7/21/2016)
i think below query might work but it shows the full history. I just want to see job name and last run date/time and durationSELECT h.server, j.name, h.run_date, h.run_time, h.run_duration
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobhistory h ON h.job_id = j.job_id
ORDER BY j.name;
Add in the filter for step_name.
AND step_name = '(Job outcome)'