Post reply

Scripting Multiple Jobs

  • July 13, 2006 at 8:16 am

    #366778

    Does anyone know how to Script out Multiple SQL Server Agent Jobs? or Transfer multiple Agent jobs from one server to another?

  • July 13, 2006 at 9:03 am

    #648999

    To script  all jobs in particular server got to enterprise manager ->Management -> sql server agent -> Jobs.

    right click on the jobs and go to All tasks->Generate sql script.

    Hope this is what you are looking for.

     

    Thanks,

    SR

     

     

     

    Thanks,
    SR

  • July 14, 2006 at 7:37 am

    #649242

    I think you cannot script multiple jobs VIA EM...But you can transfer all the jobs you want to another server using DTS.

     

    Hope this helps

    Thanks,

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

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