sqlsql-serversql-server-2008-r2database-replicationmerge-replication

How to check replication snapshot agent status?

I'd like to check the status of the agent after I start it using this statement

EXEC sp_startpublication_snapshot @publication

As I want to do a next step that needs the job to be already started.

Solution

  • After some research I got a work around way 

    SELECT snapshot_ready FROM sysmergepublications

    This query returns 0 if not ready and 1 if started

    Thanks all for your contribution :)