Apologies if this is obvious, but it's such a simple task, and yet I cannot figure out the easiest way to accomplish it.
Basically I want a monitor in APM to run an SQL query, which will return some records, and email the results of the query to someone.
The only way I saw this was to use a script monitor and create a vbscript to accomplish this.