SQL Server Performance Forum – Threads Archive
Stored Procedure to kick-off ReplicationI’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… ———-
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.