Home / server / Questions / 10557
Accepted
Chris_K
Asked: 2009-05-21 13:30:52 +0800 CST

SQL Server 2005: Copy SQL Server Agent Job?

  • 772

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an option for jobs, I'm looking for suggestions on what would be the best way to create a new job based on the first.

Edit: I just noticed that I can right-click and "Script Job As". I suppose one option would be to do just that and edit the script for my changes. I'm still curious as to if there are any other (better?) options as well.

sql-server sql-server-2005 ssms ssis agent

3 Answers

  1. Best Answer

    I don't think there is a better option than scripting your job. You can modify the script as required and reapply it to any number of SQL instances (always backup your system databases before apply scripts).

    • 8

  2. You may find the SQL Server Integration Services Task, Copy Job to be of use.

    http://msdn.microsoft.com/en-us/library/ms137568(SQL.90).aspx

    • 2

  3. I used the "Script Job as" and selected "Create To" and "New Query Editor Window". Once it was in the query editor window, I changed the name of the job and ran the code. It created an exact copy of the initial job on the same server. Success!

    • 2