Post reply

How to script sql jobs to another server?

  • February 3, 2009 at 8:23 am

    #127710

    If I export jobs from sql 7.0 as a script, How do you get them into sql 2005?

    Thanks

  • February 3, 2009 at 8:38 am

    #937178

    chris.bunt (2/3/2009)

    If I export jobs from sql 7.0 as a script, How do you get them into sql 2005?

    Thanks

    I have never done it from SQL 7.0 to 2005 but if I remember everything right you can simply execute the script on the 2005 server. Only thing to check is that all the databases must exist and if you use operators and alerts those must be created too before the jobs are created.

    [font="Verdana"]Markus Bohse[/font]

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

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