While this video does not appear under "Videos" in the profile tab, it is part of videos on The Code Project. If you are interested in hosting a video on a coding solution on Code Project, email us at submit [at] codeproject.com.
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
- SQL Server Database Mail system
- Setup Operator
- Use it to get notified wherever there is a glitch in any SQL Job or replication.