{"description":"SQL Agent can be configure to notify an operator when a job fails. While failed jobs also surface in the monitoring, proactive notification often allows for a quicker response.","name":"Jobs without notification","tsql":"SELECT      COUNT(*)\r\nFROM        msdb.dbo.sysjobs       AS j\r\nLEFT JOIN   msdb.dbo.syscategories AS s\r\n       ON   s.category_id = j.category_id\r\nWHERE       j.notify_email_operator_id = 0                          -- No operator\r\nAND         COALESCE(s.name, '')               <> 'Report Server';  -- Exclude Report Server jobs","instances":true,"databases":{"mode":1},"frequency":86400,"rateofchange":false,"metricenabled":true,"alertname":"Jobs without notification","alertdescription":"One or more SQL Agent jobs do not have notification enabled","aboveorbelow":"above","_thresholds_low":{"selected":true,"value":0},"alertenabled":true,"frequency_comment":"seconds (collected every day)","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"collections":1,"targetentitytype":0}