Options

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

dravikandravikan Posts: 4 New member
in SQL Monitor Previous Versions
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. 



Tagged:
· Share on Twitter

Answers

  • Options
    Kurt_MKurt_M Posts: 178 Silver 1
    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.

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

    · Share on Twitter
  • Options
    ElizabethKorelizElizabethKoreliz Posts: 1 New member
    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/
    · Share on Twitter
Sign In or Register to comment.