การ transfer jobs task บน MS SQL 2005

เป็นการย้ายJOB จากเครื่องหนึ่งไปยังอีกเครื่องหนึ่งครับ
ขั้นตอนก็ตามด้านล่างเลยครับ

1. Click file -> new -> project to create a new Integration Services Project
2. Click view -> toolbox so you can see an overview of all the items
3. From the toolbox, drag the “transfer jobs task” to the control flow window
4. Right click the transfer job task and click edit
5. Select jobs and enter the source and destination server, you can test the connection immediately
6. Choose to transfer all jobs, or only the ones you can select from the given list
7. Set the desired IfObjectExists and EnableJobsAtDestination option and click OK
8. Right-click the transfer jobs task and click execute task
If the job fails it will turn red, if it succeeds it turns green. Click on execution results to check for errors.
A couple of reasons why the task would fail:

• the job owner does not exist on the destination server, you can modiy this on the source server in the job properties
• if you have e-mail notifications enabled on the job, be sure the operator exists on the destination server or disable this
• if the database for which the job will be executed does not exist that job transfer will fail

hope it helps.



http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/62ca357d-74c2-4ab5-a842-ed6d9addd9a3/

Share on Google Plus

About Volk-69

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.