Configure a generic SQL action
- Last UpdatedDec 12, 2025
- 1 minute read
The AVEVA Historian does not validate the SQL query syntax. First test the SQL query using a tool such as Microsoft SQL Server Query Analyzer.
To configure a generic SQL action
-
In the Action Type list, select Generic SQL.
-
In the Action Query window, enter an ad-hoc query that detects the event. To access a list of SQL templates to use for your query, click Templates.
For information on using event system variables in your query, see Classic event subsystem.
-
To clear the window, click Clear.
-
(Optional) In the Post Detector Delay box, type the amount of time, in milliseconds, that must elapse after an event is detected before the event action can be executed.