Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server

Configure Database Mail, Operator and Notifications in SQL Server

4.33/5 (2 votes)
6 Jan 2012CPOL 17.6K  
This video explores how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired.

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

  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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)