How to block or ignore alerts from certain user
sql-lover
Posts: 39
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?
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
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
Technical Support
Red Gate Software Ltd.