Struggling with regex filtering for Long Running Queries
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:'
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?