Post reply

Jobs in SQL Server Agent..

  • April 4, 2007 at 5:10 pm

    #195004

    Hello all,

    we just moved our databases over from a SQL 2000 server onto a new SQL 2005 server. We had no problem migrating them over, but was wondering if there was a way to migrate the jobs over as well. We have about 20 of them and would prefer not to hav to create them all again on the new server.

    Thanks in advance,

    Phoenix

  • April 5, 2007 at 12:56 am

    #698724

    I usually just script all the jobs in EM. Select all the jobs you want to script, right-click them and select "generate script"

    Markus

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

  • April 5, 2007 at 1:00 pm

    #698904

    MarkusB,

    thank you for your answer. Once the script is generated and a file is created, how do I import it into the new SQL Server Agent.

    Cheers,

    Phoneix

  • April 6, 2007 at 1:10 am

    #698985

    Just execute the script in query analyzer and it will create the jobs.

    Markus

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

  • April 6, 2007 at 9:00 am

    #699025

    "Just execute the script in query analyzer and it will create the jobs"

    or, since this is SQL 2005, in a query window of SQL Server Management Studio.

    Greg

    Greg

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

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