[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

Copying jobs in MS SQL

I have created some long (20+ steps) jobs in SQL to manage backups. I would like to copy them to another job and make some minor changes. I have noticed the "generate script" option. How does that work?
0
Jim_Mead
Asked:
Jim_Mead
  • 4
  • 2
1 Solution
 
SashPCommented:
It creates the TSQL necessary to recreate the job.

Exactly what you need.

Sash
0
 
SashPCommented:
Select the create SQL Script option, select a destination for the script and thats it.

You will be able to identify the job steps that you are after and copy them to a new job fairly easily.

Sash
0
 
Jim_MeadAuthor Commented:
Thanks. Do you just execute script in the query analyzer?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
SashPCommented:
Yes.

Doing so will recreate the job.  Rename the delete job step and rename the job name and run it and you will have a copy of the job.

Sash
0
 
SashPCommented:
Sorry I should have said "Remove the delete job step"
0
 
Jim_MeadAuthor Commented:
Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now