Post reply

Stored procedure to copy sql agent jobs from one server(prod) to another server (test)

  • October 9, 2008 at 3:15 pm

    #99313

    Hi,

    I need to write a stored procedure which have to generate script for all sql agent jobs on my production server and then it need to be run on my destination server like passing the parameters like destination server, obj type etc.

    So can anyone help me out please and can share your ideas...

    Thanks in advance...

  • October 10, 2008 at 9:45 am

    #883508

    I'd suggest using the "Transfer Jobs Task" in SSIS.

    _______________
    bkDBA
    0.175 seconds -- 10 year average margin of victory at the Daytona 500
    212 Degrees

  • October 10, 2008 at 11:23 am

    #883567

    I need to do that with a stored procedure and automate it so that it can be ran on any server providing the destination server as the parameter to the stored procedure.

    Thanks.

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

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