Configure Database Mail, Operator and Notifications in SQL Server
/ masterkeshav
There has been a lot of queries asking me to post a something on how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired. To be able to fix these issues its really important to get notified in time as timely notification can only lead to timely resolution.
I have demonstrated the same in this video session. You will learn to setup
1.) SQL Server Database Mail system
2.) Setup Operator
3.) Use it to get notified wherever there is a glitch in any SQL Job or replication.