Exclude specific SQL Agent job from monitored servers at group level.

dravikan

Hi Team,

I wanted to exclude a particular SQL agent from monitoring ,
so I used an expression like [entered job name here] to configure the alert under Exclude jobs with names matching the following regular expressions field. 

after I configured the SQL alert using the expression above, for some reason , SQL monitor stopped reporting job failing alerts and stopped logging the failure alert. 

is there any way we can use a expression to exclude a specific job name at Monitored server group level. 

Thanks in advance. 

Kurt_M

Hi @dravikan

The brackets shouldn't be required, as I have tested this in my own environment and found that it can have the brackets or not. It works either way.

In saying this, I've tried to replicate the issue you've encountered, but have been unable to do so. With or without brackets, the failed job alerts still come through should another job with a different name fail.

It could be possible that you're on an older version of SQL Monitor, so please make sure that's updated. My testing was done on 12.0.12.20155.

ElizabethKoreliz

Hello! Elevate your career with Kotlin in Japan's dynamic technology industry landscape. Our company focuses on recruiting talented Kotlin developers with exceptional job prospects throughout Japan. Whether you're passionate about building Android apps or deep into backend development, we're here to make your transition smooth and rewarding. https://www.jptechjobs.com/kotlin-jobs-in-japan/