Auto email Transactional replication status.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chen - 19 Aug 2008 16:46 GMT

Hi All,

Currently we are using SQL Server 2005 Enterprise Edition with (SP2). I set
up the auto email to show status of transactional replication that I execute
the following statements: exec distribution.dbo.sp_replmonitorhelppulocation
'publication_name', 'db_name'

The email with attached file contains transactional replication status (1 =
Started, 2 = Succeeded, 3 = In progress, 4 = Idle, 5 = Retrying, and 6 =
Failed) to operators.

I try to modify it when the status equal to 5 or 6 then email to operators.
Otherwise no email goes out.

Can someone help me?

Regards!
Chen

Reply to this Message

Paul Ibison - 23 Aug 2008 18:15 GMT

Create a temp table and then insert the values into the temp table from the
proc:

Insert into #yourtable (your cols)
Exec distribution.dbo.sp_replmonitorhelppulocation

Then do a select of the status to determine if the email should be sent.

HTH,

Paul Ibison (www.replicationanswers.com)

Reply to this Message