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 Slack messages.


Purchasing Options



Available Actions

Send Slack Alerts

Post messages in a Slack channel 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.


Slack Parameters
slack_connection required

Token to use to authenticate with the Slack workspace containing the channel to post in.

channel required

Channel to post the message in.

message required

Message to post in the Slack channel. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included in a code block using the variable 'detail_results_cb'