How to block or ignore alerts from certain user

sql-loversql-lover Posts: 39
edited June 3, 2015 2:18PM in SQL Monitor Previous Versions
I do use Ola Hallengren backup solution on all SQL servers. During the weekend, the jobs run and they take quite a bit to finish; this is normal. But Monday morning, I have tons of alerts due this.

I tried to filter based on TSQL statement but this does not work, as the statement vary. I want a more general type of filter. The user that connects to SQL server and runs the jobs is not actually the same SQL server service so I wanted to ignore or filter by that.

Is there any way on SQL Monitor to ignore Long Time Running queries or alerts from a given user?

Comments

  • Hi!

    Thanks for your inquiry. We have created a new ticket for this situation, and will be responding to you via that ticket for further investigation.

    Thanks!

    Rick
    Ricky Ram
    Technical Support
    Red Gate Software Ltd.
Sign In or Register to comment.