Use the result of a set of SQL Steps run against a SQL Server database to send Slack messages.
Post messages in a Slack channel based the results of a set of SQL Steps.
Variables
Credentials to use to access the SQL Server database.
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.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL steps to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.
Token to use to authenticate with the Slack workspace containing the channel to post in.
Channel to post the message in.
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'