Sanpshot Agent won't start

[LeonAtRC]

I created a publication and then a subscriber. The replication works fine.
Then I generated a script to initialize the publisher/subscriber programatically.
The publisher and subscriber are created properly but the snapshot agent won't start.
Is there another command I can but into the script, (or another script,) to get it to start?

Thanks,
Leon

 

[mrdenny]

Replication agents are just SQL jobs. Use sp_start_job to start the job (and therefor the agent).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[LeonAtRC]

Thanks Denny. Here's the code I used. Query analyser tells me:
"The command(s) completed successfully."
But in EM nothing happens to the Snapshot Agent.
Is my syntax wrong?

Leon

sp_start_job 
	@Job_Name = 'SnapShot',
	@Server_Name = 'SQLSERVER',
	@Step_Name = 'Start'

 

[LeonAtRC]

Denny,
I jumped the gun and asked for help before searching BOL. I found out how to find both the job name and step.
Works great!
Thanks again.
Leon

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com