Struggling with regex filtering for Long Running Queries
CurryLover
Posts: 1 New member
I want to filter out alerts for certain long running queries.
Here's an example of part of an alert
So, any time this is alerted, I want to exclude it.
I've gone into the Long Running Query Notification page and set the following in the field 'Exclude queries that contain SQL commands or objects matching the following regular expressions:'
StartAgentJobAndWait
When I do this, it has the effect of stopping ALL long running query alerts from being generated.
Can anyone please tell me what I'm doing wrong?
thanks
Here's an example of part of an alert
SQL process fragment Process Full Command: CREATE procedure [dbo].[StartAgentJobAndWait](@job nvarchar(128), @maxwaitmins int = 5) --, @result int output)
So, any time this is alerted, I want to exclude it.
I've gone into the Long Running Query Notification page and set the following in the field 'Exclude queries that contain SQL commands or objects matching the following regular expressions:'
StartAgentJobAndWait
When I do this, it has the effect of stopping ALL long running query alerts from being generated.
Can anyone please tell me what I'm doing wrong?
thanks