Stop notification
DBdave
Posts: 14 Bronze 1
How can stop this Long Query Notification notification!!!
Process ID: 62
Process name: Microsoft SQL Server Management Studio
Database: XXXXXX
Host: XXXXXXXXX
User: XXXXXXX
Process login time: 15 Aug 2014 4:15 PM
Query start time: 15 Aug 2014 4:15 PM
Query duration: 4.9540001 sec
SQL process fragment
Command Type: BACKUP LOG
I have added this into my Alert Settings configuration for long running queries:
Exclude queries with a SQL process name matching the following regular expressions:
[Bb]ackup|BACKUP LOG|BACKUP
Exclude queries that contain SQL commands or objects matching the following regular expressions:
[Bb]ackup|BACKUP LOG|BACKUP
Thanks
D
Process ID: 62
Process name: Microsoft SQL Server Management Studio
Database: XXXXXX
Host: XXXXXXXXX
User: XXXXXXX
Process login time: 15 Aug 2014 4:15 PM
Query start time: 15 Aug 2014 4:15 PM
Query duration: 4.9540001 sec
SQL process fragment
Command Type: BACKUP LOG
I have added this into my Alert Settings configuration for long running queries:
Exclude queries with a SQL process name matching the following regular expressions:
[Bb]ackup|BACKUP LOG|BACKUP
Exclude queries that contain SQL commands or objects matching the following regular expressions:
[Bb]ackup|BACKUP LOG|BACKUP
Thanks
D
Comments
Possibly consider using:
BACKUP/sLOG
(assuming that the SQL Process will always be in capitals and it is all backup log jobs you want to ignore).
(/s is the escaped character for 'space')
It may take some trial and error to get exactly the behaviour you are looking for.
RegExLib.com may also help:
http://regexlib.com/CheatSheet.aspx