Want to stop notifications for Long Running Queries
NC Software
Posts: 9 Bronze 2
Hello,
I recently installed SQL Mon 4, never used any prior version. I also use RG's SQL Backup and everytime it runs SM4 sends me alerts on long running queries which I want to stop. What do I need to put into the exclude box(es) to make this work so SQL Server backup and/or Red Gate SQL Backup does not trigger this alert? I tried the following in the top box and it doesn't work:
[Bb]ackup
SQLAgent
Thank you.
I recently installed SQL Mon 4, never used any prior version. I also use RG's SQL Backup and everytime it runs SM4 sends me alerts on long running queries which I want to stop. What do I need to put into the exclude box(es) to make this work so SQL Server backup and/or Red Gate SQL Backup does not trigger this alert? I tried the following in the top box and it doesn't work:
[Bb]ackup
SQLAgent
Thank you.
Comments
I'm pretty sure the name of the SQL process you want to exclude is sqlbackup
This would go into the top box on the Alert configuration settings for Long-Running Query.
Thanks,
Colin.
[Bb]ackup
SQLAgent
sqlbackup
Thanks,
Colin.