How to find the replication frequency

Hello,
We are getting the replication data from some other database. Our
replication method is push method. How to find out the frequency of the
replication process per day? I have to find out this from the subscription
database side.
Regards,
Sunil
Sunil,
this should be what you want:
exec msdb..sp_help_jobschedule @.job_name = 'distributionagentname'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you Paul.
But i don't have access to the distribution server. I am having access to
only subscriber database which is of type push. And in the subcriber side
we don't have jobs for replication in the push type. How to find out now?
Thanks,
Sunil
Message posted via http://www.droptable.com
|||As it is push, you can open up Query Analyser connection to the
publisher/distributor and run the query there. You could also do this
through a linked server sitting on the subscriber. If you don't have any
connectivity at all, then I don't see how this is possible. You could
possibly derive it from the MSsubscription_agents table, but this is messy.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello Paul,
I don't have connection info for the distributor server. In the subscriber
database having two tables 'MSreplication_subscriptions' and
'MSsubscription_agents' tables. In the first table, one field is there
namely 'time'. Is this field gives info when the replication occured?
Thanks,
Sunil
Message posted via http://www.droptable.com
|||The lastsynctime in MSsubscription_agents is what I was thinking of - it
doesn't maintain a history, but if you poll it you should get an idea of the
frequency.
Rgds,
Paul Ibison, SQL Server MVP