sp_startpublication_snapshot for SQL Server 2000

[teqmem]

Hello,

In SQL Server 2000, is there a similar procedure to SQL Server 2005's "sp_startpublication_snapshot" procedure?

I have a transact-sql script that creates a publication and I would like to automatically start the snapshot agent for this publication.

Thanks.

 

[mrdenny]

Get the jobid from the replication tables and use sp_start_job to start the SQL Agent job.

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)

My Blog