Toad World® Forums

How do I automate email when record NOT found?


I have a sql server database cash register. Each day the cash register is closed and writes a record to a table, inlcuding the date/time it was closed. I want to automate TDA to send me an email if there is NOT a record in the table with today’s date. If the record is found in the table with today’s date, I don’t want to get the email.

TIA for any help.



I would use the Row Count variable. You would execute a query and if the row count is 0 send the email. See my blog posting on exception reporting.