I need to create a SQL job to send an email to some dept whenever two sql tables are changed (updated)
I created a audit table with columns user, last_updatedate, old_value and new_value,and a identity column
and also Created a two update triggers whenever target 2 tables are updated log the information to audit table.
Basically I am looking for a code whenever a new row inserted into audit table send an email with the data. and put this code into sql job to run as per schedule. Thanks