Pause/restart replication with SQLSERVER 7 SQL command

[SQLSquirrel]

We have several data extracts on a single MI database which is fed by replication from 5 other databases - on 5 other servers. I recently paused replication (manually on all 5 servers) and this seemed to improve the MI extracts performance (run by SQL:Agent tasks). Now I'd like to pause/restart replication automatically also from within SQLAgent tasks but cannot find an appropriate SQL command within books-online for SQLServer 7 - does anyone know what the command(s) are?

 

[mrdenny]

SQL Replication is controlled through jobs. Use the sp_start_job and sp_stop_job to control the jobs.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com