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




Description

Send alerts when an SQL Query evaluates to true.


Purchasing Options



Available Actions

Send Email Alerts

Send email messages with the content specified based on SQL Query results.


Variables

Database Parameters
target_db required

MySQL Database to run the SQL Steps on.

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.

post_sql_query

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

user_params

Parameters to use in your SQL Steps, 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.


Send Email Alerts Using Google Cloud Platform

Send email messages with the content specified based on SQL Query results.


Variables

Database Parameters
target_db required

MySQL Database to run the SQL Steps on.

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.

post_sql_query

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

user_params

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


Email Parameters
gcp_connection required

Credentials to connect to GMail SMTP.

alt_from required

E-mail address of the GMail user that the service account will impersonate as the sender of the message.

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.