What are the challenges you face when working across database platforms? Take the survey
Options

Struggling with regex filtering for Long Running Queries

I want to filter out alerts for certain 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:'

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
Sign In or Register to comment.