PKTG
asked on
How to move SQL Serer Agent Jobs from one server to another?
I want to move Sql Server Agent Jobs from one SQL Server server 2008 to another SQL Server 2008 Machine in the same network with different Owner name. Please let me know what is the best method for this task? I need to move jobs to many new servers. In some serers we already deployed some jobs manually so in this machine i should move only missing jobs. Please guide me. Thanks.
ASKER
These are SSIS jobs . So i need to deploy each server manually then need to run the script.Is there any way i can transfer SSIS jobs also?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Taken from that thread:
"In SSMS you can select a SQL Agent job, right click and script it as a
CREATE. That will give you a script that you can run on another server to
create the same job.
By the way, if you select the SQL Agent / Jobs node of Object Explore and
the use the Object Explore Details window, you can select several jobs,
right click and create a single script with all the selected jobs.
Of course, you need to make sure that all dependencies are met on the other
server. Such things as logins, SQL Agent proxies, DTS/SSIS packages, and so
forth.
RKF"