snippetsqlMinor
How to move a SQL Agent Job to another Server?
Viewed 0 times
sqlagentmoveanotherhowserverjob
Problem
I'm moving from SQL Server 2005 to SQL Server 2008R2, and I see there is one job in the SQL Server Agent Jobs that I need to move but I see it also in the SSIS---> Stored Packages\MSDB\File Manipulation.
Not sure if I right click on it and choose export, would that affect the production server if it wont be working in the new dev server? or how I can import just a copy of it to the other new development SQL server 2008?
Thanks for any advice or direction.
Not sure if I right click on it and choose export, would that affect the production server if it wont be working in the new dev server? or how I can import just a copy of it to the other new development SQL server 2008?
Thanks for any advice or direction.
Solution
If you're talking about moving SQL Server Agent Job, I suggest you use the option "Script Job as -> Create" and than copy and paste the code on the new server. Once you have the code on the new server you can edit it (or execute it and than edit the job through Job Properties window) so it could work in a new enviroment.
Context
StackExchange Database Administrators Q#55278, answer score: 4
Revisions (0)
No revisions yet.