xileb0 xileb0 - 5 months ago 24
SQL Question

How can I check how often a replication agent is executed?

Is it possible to check (in an existing replication) how often the replication agent is executed? (For example every 5 minutes, every 2 weeks,...)

I can't find it in the SQL-Server Agent.

Answer

You can use.

    select * from MSlogreader_agents
    select * from MSdistribution_agents
    select * from MSdistribution_history
    select * from MSlogreader_history

in distribution database.

And to view schedule you can join MSlogreader_agents, MSdistribution_agents with msdb.dbo.jobschedules.

Thanks.

Comments