Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating Alert and Notifications for Replication Issues on SQL Server 2005!!! Expand / Collapse
Author
Message
Posted Monday, August 06, 2012 1:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 12:35 AM
Points: 34, Visits: 239

Hi All,

I have been assigned a Task to set up Alert and Notifications for all the Issues arising in Replication i.e. :

1. Any issue arising in Publisher
2. Any issue arising in Distribution
3. Any issue arising in Subscriber

If I am not able to implement all of the above, the least that I have to do is to create Alert and Notification for the 3rd point-Any issue arising in Subscriber

Could you guys please help me or give me an idea how can I setup Alerts and Notifications for the above scenarios?

Thanks
Devesh
Post #1340383
Posted Monday, August 06, 2012 3:01 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
Alerts here -> http://msdn.microsoft.com/en-us/library/ms180982.aspx
Replication here -> http://msdn.microsoft.com/en-us/library/ms151198.aspx
Replication with alerts here -> http://technet.microsoft.com/en-us/library/ms151752.aspx
and here -> http://msdn.microsoft.com/en-us/library/aa237180(v=sql.80).aspx
and here -> http://www.mssqltips.com/sqlservertip/1901/customized-alerts-for-sql-server-transactional-replication/

Hope this helps.


---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
Post #1340426
Posted Tuesday, August 07, 2012 7:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 12:35 AM
Points: 34, Visits: 239

Guys,

More suggestions will be highly appreciated!!!!!

Thanks
Devesh

Post #1341218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse