How can I move SQL Server Agent Jobs to different systems?
See how to move SQL Agents jobs between systems
January 15, 2015
![How can I move SQL Server Agent Jobs to different systems? How can I move SQL Server Agent Jobs to different systems?](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/blt48d2c6f112ba734e/661814309af6614e72a058e4/qawebartdarkblue_0_4.jpg?width=1280&auto=webp&quality=95&format=jpg&disable=upscale)
You can move SQL Server Agent jobs to different systems by using the Script Job option from SQL Server Management Studio (SSMS). This will create a T-SQL script that you can run on another server. When the script executes on the target server your SQL Agent Job will be created on that server.
To script a SQL Server Agent Job open SSMS expand the SQL Server Agent node then expand the Jobs node. All of the SQL server Agent jobs will be listed. To use the Script Job option right the job that you want to move and then select that Script Job as option from the context menu followed by the CREATE To and File option like you can see in Figure 1.
![](https://cet.informabi.com/sites/sqlmag.com/files/uploads/2015/01/Script%20SQL%20Agent%20Job.jpg?width=595&auto=webp&quality=80&disable=upscale)
Figure 1 - Script SQL Agent Job
You’ll be prompted for a file name and location. Running the option will create a T-SQL file (.sql) that you can run on your target SQL Server instance.
About the Author
You May Also Like