Posts Tagged ‘Job details’

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