You can't use this until you register with us!

Description

Use the result of a set of SQL steps run against a SQL Server database to send emails.

Purchasing Options

SQL Server to Email Alerter - $49.99 / month

Available Actions

Send Email Alerts

Send emails based the results of a set of SQL steps.

Variables

Source Parameters
db_connection required

Credentials to use to access the SQL Server database.

sql_steps required

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.

detail_sql_query

Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.

post_sql_query

SQL steps to run after alerts are sent. Does not generate new alerts.

user_params

Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.


Email Parameters
smtp_connection required

SMTP Server to use.

alt_from

If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.

to required

Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.

cc

Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.

bcc

Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.

subject required

Subject content of the email.

body required

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'

add_row_labels

Enable to add a number at the beginning of each row in the result table.

column_alignment

Define how the data in each column should align. Left alignment will be used if unspecified. Refer to slide out help for more information.