May 16, 2016 at 7:32 am
Hi,
I would like to create an alert which fires off an email when un-distributed transactions in transactional replication have reached a certain limit (or are over a certain limit).
What is the easiest method of doing this?
Thanks.
May 16, 2016 at 8:15 am
Perform a count on subscriber and publisher and compare?
May 16, 2016 at 8:19 am
Will give it a try, thanks.
May 16, 2016 at 8:23 am
I have tried using
sp_replmonitorsubscriptionpendingcmds
and although this provides me with the right data, how can I manipulate the columns output?
For example executing the above gives me two columns in the output:
pendingcommandcount
estimatedprocesstime
In my script I want to say if pendingcommandcount > 50,000
do whatever here
How can I do this?
May 16, 2016 at 8:29 am
May 19, 2016 at 9:33 am
That worked thanks.
May 23, 2016 at 1:39 am
No problem!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply