Return
-
Title
Change to Long Running SQL alarm -
Description
How to receive the full query text of a Long Running SQL alarm. Right now, the object in the alarm is "LongRunningSQL.query_text_short".
-
Resolution
WORKAROUND:
Set up an alarm action to send out the full query text by email, for example:
Spotlight has raised an alarm:
Connection: {{CONNECTION_NAME}}
Time: {{TIME}}
Severity: {{SEVERITY}}
{{ALARM_NAME}}: {{MESSAGE}}
Full query text:
{{LongRunningSQL.query_text}}
-
Defect ID
PT 51532529