Send alerts when an SQL Query evaluates to true.
Send email messages with the content specified based on SQL Query results.
Variables
MySQL 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.
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.
Send email messages with the content specified based on SQL Query results.
Variables
MySQL 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.
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.
Credentials to connect to GMail SMTP.
E-mail address of the GMail user that the service account will impersonate as the sender of the message.
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.