How to transfer SQL Agent Jobs using SSIS with Job owner

Bala Narasimha Challa 466 Reputation points
2021-11-01T07:57:02.8+00:00

Hi Team,

Want to transfer SQL Agent Jobs using SSIS with Job owner one server to another server.

Thanks in advance

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,581 Reputation points
    2021-11-01T08:29:52.923+00:00

    Hi @Bala Narasimha Challa ,

    You may use Transfer Jobs Task in SSIS package to transfer SQL Agent Jobs.

    The Transfer Jobs task transfers one or more SQL Server Agent jobs between instances of SQL Server.

    The Transfer Jobs task can be configured to transfer all jobs, or only specified jobs. You can also indicate whether the transferred jobs are enabled at the destination.

    transfer-jobs-task

    You may also take a reference of the task sample transfer-sql-server-jobs-task-and-transfer-sql-server-logins-task-in-ssis.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.