How to block or ignore alerts from certain user

sql-lover

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?

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