Post reply

sql server agent jobs

  • March 21, 2013 at 11:06 am

    #270073

    Can anyone tell me how can i copy the sql server agent jobs easily from production to test server without schedule?

    Does scripting 'create job' script from prod and running it on test works?

    Thanks a lot.

  • March 21, 2013 at 12:25 pm

    #1599527

    You can script the jobs from prod using SSMS but note that it will include the schedules.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 27, 2013 at 6:45 am

    #1601115

    Once you generated Script, plz remove the ID ...

    Bcoz once u execute the same script on Test , SQL Server of test Environment will generate id.

  • April 2, 2013 at 1:15 am

    #1602683

    What that messy text speak above means is that you need to delete the line that sets a guid value for the schedule id and probably the comma on the previous line. Otherwise this is exactly how I move my agent jobs.

    If you study the script you can see how to edit it to amend or remove the schedule if you so wish.

  • April 4, 2013 at 1:37 pm

    #1603722

    Thanks everyone

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

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