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.
I am a Microsoft certified Technology Specialist in MS SQL Server 2008 and 2005.I have fair amount of experience and expertise in MS database development, administration and modeling and MS BI. Started my career in 2007 and primarily into MS databases, and later diversified into MS BI especially SSIS. I also have a little exposure in Oracle 10g while working on one of the migration projects. But MS SQL Server is my passion!
Firm believer in knowledge grows from sharing, I really like reading books, trying new features and sharing the little that I know. Unless we're willing to have a go, fail miserably, have another go, success won't happen. The best thing I have discovered about myself is the "never say die" attitude. The best comment I have ever received is when my manager at my first job said "when this guy works he throws away his watch".