How to: Check the Status of the Snapshot Agent (SQL Server Management Studio)
In this topic, you will learn how to examine the status of the snapshot agent in both Microsoft SQL Server 2000 and SQL Server 2005. You use the Replication Monitor to examine the status of the Snapshot Agent and ensure that the snapshot has been created.
To examine the status of the Snapshot Agent with SQL Server 2000
On the computer that is running SQL Server 2000, start SQL Server Enterprise Manager: Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
In the console tree, expand Microsoft SQL Servers, expand SQL Server Group, expand the computer that contains the Distributor for the publication, expand Replication Monitor, and then click Agents.
In the left pane, click Snapshot Agents. The status of the Snapshot Agent is displayed in the right pane.
To display more information about an entry listed in the right pane, double-click the entry.
If the Snapshot Agent for the publication has not started, right-click the agent entry in the right pane, and then select Start Agent.
To examine the status of the Snapshot Agent with SQL Server 2005
On the computer that is running SQL Server 2005, start SQL Server Management Studio: Click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.
In Object Explorer, expand the computer that contains your publication, and then expand Replication.
Right-click Replication, and then choose Monitor Replication.
In Replication Monitor, expand My Publishers, expand the server, and then select the publication.
In the right pane, select the Warnings and Common Agents tab to view the status of the Snapshot Agent.