{"name":"SQLAgentJobsOwnedByTheWrongPerson","description":"One or more SQL Agent jobs exist that are not owned by the database owner. You should fix these jobs so that they're owned by the appropriate person. If the owning account is removed from Active Directory, the job may fail.","tsql":"DECLARE @db_owner_sid AS VARBINARY(85);\r\nSELECT @db_owner_sid = s.sid\r\nFROM sys.sysusers AS s\r\nWHERE s.uid = 1;\r\nSELECT COUNT(*)\r\nFROM msdb..sysjobs AS sj\r\nWHERE sj.owner_sid <> @db_owner_sid;","instances":true,"databases":{"mode":1},"frequency":86400,"metricenabled":true,"noalertremark":"N\/A","frequency_comment":"seconds (collected every hour)","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}