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?