The Long Running SQL Alarm alarm allows the user to specify to not alarm for certain values, however the value in this case is the SPID of the process. Ideally it would be useful if the user could ignore the alarm based on certain text in a SQL query string.
The alarm ignore list works on the key column, in the case of Long Running SQL, this is the spid.
This means the user can ignore this alarm for a specific spid but the user cannot ignore alarms for sql's that contain specific text.
WORKAROUND:
Modify the alarm message to include the column with the keyword and then set up an alarm action for those specific keywords to supress the alarm, the attached document is an example using the program name column.
STATUS
Enhancement request has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
