Post reply

Conditionally Start Replication

  • February 28, 2009 at 2:48 pm

    #200830

    Hi,

    Can I start a SQL 2005 Snapshot replication based on the status of another job?

    I'm thinking to add a step in the Replication Publisher Job to check the status of another job to decide whether or not to start the replication.

    Regards,

    Michael

  • February 28, 2009 at 2:58 pm

    #951545

    The snapshot agent runs as a job. Don't give it a schedule and then, in your other job, when you want it to start, call sp_start_job with the name of the snapshot agent job.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 5, 2009 at 2:37 pm

    #954443

    Thanks for your help.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply