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.