I have set up an automation script to email me the result of a select query.
The select query is a simple one of the form: Select Count(*) From Table
I’d like to set up the script such that I get an email ONLY if the result is greater than zero. Basically, I want to receive an alert if the query returns a non-zero result.
There do not seem to be any options within the UI to set up a conditional of this type. I suspect the Toad Automation Script file could be manually edited to contain this kind of conditional - but I’m not sure how to go about it.
Can anyone offer advice?