SELECT

sj.name,

so.name,

max(run_date) [LastRunDate]

FROM

msdb.dbo.sysjobs sj

inner join msdb.dbo.sysjobhistory sjh

on sj.job_id =sjh.job_id

inner join msdb.dbo.sysoperators so

on sj.notify_email_operator_id = so.id

GROUP BY

sj.name,

so.name