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

Description

Send an email alert when an last statement of sql query evalutes to true. Uses Jinja Templates from results to render messages.

Available Actions

Check Alert

If an SQL statement evalulates to True, send an alert

Variables

target_db required

Database where you want to run the script on.


smtp_connection required

SMTP Server to use


Email Parameters
body required

Contents of the email body to be sent.

from required

From

to required

Send email to this address

subject required

Subject of the email to be sent

sql_query required

SQL Query/Queries to run. Last statement can return multiple rows and columns. Must have a "sendalert" column which returns True/False. Email will be sent when "sendalert" evaluates to True


post_sql_query

SQL Script or steps to run after sending of e-mails. Does not send alerts.


user_params

If in your sql you use any parameters then you need to create a parameter list here. To use ranges visit ...