Ability to define a monitoring alarm based on the result of a Secure SQL Query
I have the following use case: I want to send an email with the content of a Secure SQL query but only if there are records returned by the SQL Query (or if there are no records for example).
Unfortunately this is not possible.
David Grospelier shared this idea
This feature is available in the latest BizTalk360 version 10.6. The secure SQL Query results can be monitored in data monitoring.
Refer this document