Finding SQL Server Job details having no operator for notification

As a DBA, sometimes it’s may be happened you forgot to set a notification to a job, here is a very simple script to find out which job have notification or not.

Select SJ.Name Job_Name,
Case SJ.Enabled when 1 then ‘Enabled’ else ‘Disabled’ end Enable_Status,
SJ.description Job_Description,
SUSER_SNAME(owner_sid) Job_Owner,
SJ.date_created Job_Created_Date,
SJ.date_modified Job_Modified_Date,
SP.Name Operator_Name,
SP.email_address Emails,
SP.last_email_date Last_Email_Date,
SP.last_email_time Last_Email_Time
from msdb..sysjobs SJ
LEFT JOIN msdb..sysoperators SP on SP.ID = SJ.notify_email_operator_id