Send alerts based on SQL Query results.
Send e-mail messages based on SQL Query results.
Variables
Redshift Database to run the SQL Steps on
SQL Steps to run. Last statement result can be multiple rows and columns. Result must have a 'sendalert' column that contains a True or False value.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL Query to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps, if any. Refer to slide out help for more information.
SMTP Server to use.
If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.
Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.
Subject content of the email.
Body content of the email. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included as an HTML table using the variable 'detail_results'
Enable to add a number at the beginning of each row in the result table.
Define how the data in each column should align. Left alignment will be used if unspecified. Refer to slide out help for more information.