question

balanarasimhac-1495 avatar image
1 Vote"
balanarasimhac-1495 asked ZoeHui-MSFT commented

How to transfer SQL Agent Jobs using SSIS with Job owner

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @balanarasimhac-1495,

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @balanarasimhac-1495,
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·