OK, so you just have to query sysjobservers:

SELECT last_run_outcome -- 0 = Fail

-- 1 = Succeed

-- 3 = Cancel

FROM msdb.dbo.sysjobservers sjs

INNER JOIN msdb.dbo.sysjobs sj

ON sj.job_id = sjs.job_id

WHERE sj.name = 'YOUR JOB NAME'