SELECT
j.name,
j.enabled,
j.description,
l.loginname AS owner,
j.notify_level_eventlog,
j.notify_level_email,
j.notify_level_netsend,
j.notify_level_page,
o.name AS Operator,
o.enabled AS OperatorEnabled,
o.email_address AS Operator_email_address,
j.date_created,
j.date_modified,
j.version_number,
j.job_id
FROM msdb.dbo.sysjobs AS j WITH (NOLOCK)
LEFT OUTER JOIN msdb.dbo.sysoperators AS o WITH (NOLOCK)
ON j.notify_email_operator_id = o.id
LEFT OUTER JOIN master.sys.syslogins AS l WITH (NOLOCK)
ON j.owner_sid = l.sid
--WHERE o.name IS NULL