Moving Jobs between servers

  • Hi,

    I just want to make sure that If i script out all the jobs and run them on to a new server,Having all the objects in place on new server ,will i be able to create them without any issue??

    Are there any known issues doing this way??

    The reason for me to do this i have to move only few jobs.

    Thanks for your response.

  • I move jobs this way all the time. The main problems I have are around job owners, and the operators being notified. Make sure the job owners are correct for the new server, and that the operators exists.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • Thankyou Greg Larsen for your help.

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

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