How can we help you today? How can we help you today?

How to block or ignore alerts from certain user

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?
sql-lover
0

Comments

1 comment

Sort by
  • RickyR
    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
    RickyR
    0

Add comment

Please sign in to leave a comment.