Post reply

Coping Jobs

  • February 5, 2004 at 3:03 pm

    #83809

    Hi,

    I have 7 servers all running sql 2000 on win2000.  I have to add 5 new jobs to all the servers.  Is there a way to script the jobs or is there a control I could use to create the jobs.

     

    Thanks

    Mark 

  • February 5, 2004 at 3:30 pm

    #492965

    You can script all jobs in Enterprise Manager.

    Management | SQL Server Agent | Jobs.

    Right Click.

    All Tasks | Generate SQL Script...

     

    K. Brian Kelley
    @kbriankelley

  • February 5, 2004 at 3:51 pm

    #492967

    Thanks,  One other question when I try to execute the script in TSQL it tries to run the steps.   How do I install the jobs on another server?

  • February 5, 2004 at 5:35 pm

    #492974

    You can run the script through Query Analyzer. You may have to make a few small changes here and there to reflect differences between the server, but it's a basic T-SQL script.

     

    K. Brian Kelley
    @kbriankelley

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

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