Could not start the Snapshot Agent to generate a new snapshot

Post date: Sep 5, 2011 1:54:03 PM

PROBLEM:

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 ------------------------------ ADDITIONAL INFORMATION: 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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

Solution:

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