• Look at sp_start_job and sp_stop_job. You should be able to start/stop the replication agent job with these.

    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.