I have configured Database mail, test email is being sent successfully to designated recipient who were part of OPERATORS but I need to configure email alert when data comes/insert on table "abc" through executing procedure "sp_wh_negative_stock". Procedure will execute every 5 minutes, so if procedure insert data in "abc" table then generate email alert to recipient. Also need table data send by alert email. So how is it configure? Which TYPE and SEVERITY will use to configure this alert?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.