Stored Procedure to kick-off Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stored Procedure to kick-off Replication

I’m writing a web-based internal app that I would like to set up so that after a record is created a user presses a button that kicks off a stored procedure that runs the replication jobs. Kind of like a manual replication option. Has anyone done this? How would I call replication jobs from a stored procedure? Thanks… ———-
T Kelley
MS, MCDBA, OCA, CIW
Since the replication agents run as jobs. Try using the sp_start_job in the msdb database to start replication. Nathan H.O.
Moderator
SQL-Server-Performance.com
]]>