Based on David's script:

SELECT j.[name],

MAX(CAST(

STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' +

STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)) AS [LastRun],

CASE jh.run_status WHEN 0 THEN 'Failed'

WHEN 1 THEN 'Success'

WHEN 2 THEN 'Retry'

WHEN 3 THEN 'Canceled'

WHEN 4 THEN 'In progress'

END AS Status

FROM msdb.dbo.sysjobs j

INNER JOIN msdb.dbo.sysjobhistory jh

ON jh.job_id = j.job_id AND jh.step_id = 0

inner join msdb.dbo.syscategories sc

on j.category_id = sc.category_id

WHERE sc.[name] like '%DTS%'

GROUP BY j.[name], jh.run_status