Alert response – SQL Script and email

by Nov 5, 2019


I'm new to Idera and trying to configure alert responses. I want the response of a given alert to be run a SQL query and then send an email with the result of the query, however I'm not able to achieve that using the alert response interface. I can only run the sql script, but  I don't have any option to provide the output on the send email action.

Is there any way to achieve this on the interface?