Remote subscriptions status

[former_member836222]

Hello All,

I am creating a report, to get the errored status and message of replication task. I could see the remote subscriptions overview in DB explore(right click on remote subscriptions), how to get the data source of that results / is there any table/views to get the status of the replication tasks? Thanks in advance

[former_member45161]

Hi ragavendiran007,

result will be visible once we create a remote subscription

CREATE REMOTE SUBSCRIPTION <Subscription_Name> ON <Table1> TARGET TABLE <Table2>;

This comes into picture during RTR(Remote table replication) scenario

Regards

Deepak

[former_member836222]

Hello deepak150,

Thank you for your reply, my question is, what is the table/data source to get existing replication tasks status and error message.

Regards

Ragavendiran