How can I move SQL Server Agent Jobs to different systems?

How can I move SQL Server Agent Jobs to different systems?

See how to move SQL Agents jobs between systems

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.

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.

 

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish