Toad World® Forums

How do I automate email when record NOT found?


#1

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.

Marge


#2

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.

http://www.toadworld.com/BLOGS/tabid/67/EntryID/496/Default.aspx

Debbie