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

Want to monitor Replication using a Job. Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 7:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 4:48 AM
Points: 282, Visits: 116
Actually, Transactional Replication is running between Sql server 2005 to SQL Server 2000.
But, Replication Status is running fine. all agents are running fine. but the subscriber end , tables are not updating.

when I checked, through Replication Monitor, I find a message..

'The initial snapshot for publication xxxx is not yet available'.

So I reinitialized and fix the problem.

But, I want a way to be informed , when such kind of msg, or obsolete snapshot msg is showing .

So I want to create a job to monitor those activity and in the above case the job use to send a mail to me.

Do any body have better solution to overcome this issue.????

Thanks in Advance.
Post #1354509
Posted Wednesday, September 26, 2012 6:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 1,101, Visits: 5,288
Following may be better solution, still worth implementing:
1) You can create a job run Subscription Validation.
2) You can create alert for latency.
Post #1364605
Posted Friday, September 28, 2012 10:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 1:02 PM
Points: 397, Visits: 565
You can have a job at the publisher insert a tracer token periodically. If it doesn't arrive at the subscriber have a certain amount of time, the job can notify an operator to take a look for any replication errors or failures.
Post #1365996
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse