• Not sure if I'm late or not but here is one I have used:

    SELECT name,

    (SELECT MAX(run_date) AS MaxRunDate

    FROM msdb.dbo.sysjobhistory AS B

    WHERE (job_id = A.job_id)) AS MaxDate,

    (SELECT MAX(run_time) AS MaxRunTime

    FROM msdb.dbo.sysjobhistory AS B

    WHERE (job_id = A.job_id)) AS MaxTime

    FROM msdb.dbo.sysjobs AS A

    WHERE (name = 'YourJobName')