Ignore SQL Agent Jobs by name/category

[satoshidba]

Hi @DavidWiseman

Would it be possible to have the ability to ignore certain SQL Agent jobs based on some criteria such as job name or category for example with a customisable wildcard query on the name?

Just thinking along the lines of some agent jobs that we have where there is some development ongoing and regular failures are expected, don't want to disable the job but also don't want it to flag up.

Thanks

[DavidWiseman]

Thanks for the suggestion. You can disable the thresholds for individual jobs. It would be possible to automate it via a script as a workaround. Something like this:

INSERT INTO dbo.AgentJobThresholds(InstanceID,job_id,LastFailIsCritical,LastFailIsWarning)
SELECT J.InstanceID,J.job_id,0,0
FROM Jobs J
WHERE J.category='Your_Category_To_Exclude' -- Or: J.name LIKE '%Your_Name_To_Exclude%'
AND NOT EXISTS(SELECT 1 
			FROM dbo.AgentJobThresholds T 
			WHERE T.InstanceId = J.InstanceID
			AND T.job_id = J.job_id
			)

[satoshidba]

Thanks for the reply, that seems like a simple enough way around it for what would probably be a niche request!