SELECT     CONVERT(DATETIME, RTRIM(H.run_date)) + ((H.run_time * 9 + H.run_time % 10000 * 6) + H.run_time % 100 * 10) / 216e4 AS run_date, J.name, 
                      H.message, H.run_duration, H.server
FROM         LINKED_SERVER_NAME.msdb.dbo.sysjobhistory AS H INNER JOIN
                      [SRV-NAV01].msdb.dbo.sysjobs AS J ON H.job_id = J.job_id
WHERE     (H.step_id = 0) AND (H.run_status = 0)