Post reply

Can I modify the Replication Job?

  • August 28, 2007 at 1:25 pm

    #92728

    We don't have Outlook on our servers, and I want to add a step to the transactional replication agent job that on failure to use the standard SMTP sendmail sproc. Can I modify the job without killing the whole replication thing?

     

    Thanks,

  • August 28, 2007 at 3:29 pm

    #729934

    only if the agent that you are modifying is not setup to run continuosly


    * Noel

  • August 29, 2007 at 7:18 am

    #730079

    Sure, you can do it, but it won't take into effect until you restart your job if it's set to run continuously. In this case, you can easily stop and restart it, you'll have approx. 8 seconds latency

    If you modified the job, don't forget to update your saved replication scripts as well, otherwise... you'll lose it sometime.

    -- Erik http://blog.rollback.hu

  • August 29, 2007 at 10:37 pm

    #730315

    Why don't you use SQL Agent Alerts to notify you when a replication job fails ? This is standard functionality which is extremely easy to configure. Assuming you have mail properly configured this will only take a few seconds to configure and does not require any change to the replication jobs.

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

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