And this, to include category information....

select distinct cat.name as "Category", j.Name as "Job Name", j.description as "Job Description",

h.run_date as LastStatusDate, h.run_time as LastStatusTime, h.run_duration as LastStatusDuration,

case h.run_status

when 0...

I added last run time and duration, and FQDN for msdb table to allow this to be used in a stored procedure or elsewhere than Query Analyser 😀 :

select distinct...