Defining before SQL statements for alerts

Define SQL statements that the system will execute prior to executing the defined grid for an alert. Before SQL statements can be used to prepare data or structures being used by the grid, e.g., purge records.

To define before SQL statements for alerts:

Select Administration > Setup > Alert Management.
Select the alert for which to define the before SQL statement, and then click the Before SQL tab.
Specify this information:

SQL Statement

Enter the SQL statement that will be executed before the grid query will produce a result set. The system automatically populates Abort on Failure.

Note: Unselect Abort on Failure to enable the system to continue executing the grid query if the SQL statement fails.

Comments

Enter comments regarding the SQL statement.

Execute when Previewing Grid

Select to execute the SQL statement when Grid Preview is selected.

Active

Select to set this SQL statement record to active.
Note: To process the before SQL statement when the alert job is run or Grid Preview is selected on the Record View page of the Alerts form, you must select Active.
Click Save Record.

Note: Click Test SQL to check the validity of the SQL statement.