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 duration

SELECT 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;