Toad World® Forums

Easiest way to not send a blank emailed report?

We have automation in Toad data point that runs a query and auto emails the output to users. It works fine and is scheduled.

However, the report is an exception report and sometimes returns zero rows from the database. In such cases, we do not want to send out an “empty” report that just has headers.

What is the easiest way to accomplish this?

Thanks!!!


Mark E. Sunderlin
Data Architect // AOL Platforms
P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166
AIM: MESunderlin

There’s a default row count variable - simply wrap your email in a IF/Condition statement, check to see if that variable is greater than 0 - if it is, send the email, if not, don’t (or send a different email).