Just Code‎ > ‎

Could not start the Snapshot Agent to generate a new snapshot

posted Sep 5, 2011, 6:54 AM by Peter Henell   [ updated Sep 5, 2011, 6:56 AM ]
TITLE: Microsoft SQL Server Management Studio

Microsoft SQL Server Management Studio could not start the Snapshot Agent to generate a new snapshot. 
You must start the Snapshot Agent manually before the subscription(s) can be reinitialized.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.ReplicationDialogErrorSR&EvtID=CantStartSnapshotAgentForReinit&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


SQLServerAgent Error: Request to run job CYD-DB-01-sam_backoffice_db_02-sam_backoffice_db_02_publica-1 
(from User NET\peter.henell) refused because the job has been suspended.
Changed database context to 'sam_backoffice_db_02'. (Microsoft SQL Server, Error: 22022)

For help, click: 


I just had to restart the SQL Server Agent to get it to work