• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Scripting SQL DTS Packages and all SQL Jobs?

Hi all.  I am trying to do the following.  A previous company created about 10 DTS packages and there is about 20 SQL jobs.  I need to first check what all of them are doing and then I need to script everything needed and move it to another server with 2 databases.  I am thinking I will just do a full backup on the DB's and then restore and then I need to setup all the DTS packages and SQL Jobs.  Is there a scripting way to do this and also is there a way I can see everything that is being run without having to click and look at steps for each job etc?  Thanks all
0
sbornstein2
Asked:
sbornstein2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the DTS and jobs are all stored in the msdb, so if you backup and restore that database, you have them all...
0
 
MikeWalshCommented:
MSDB will also store all job related information about the server.

One other option is to save your DTS packages to a structured file. You can then save the .dts file and reimport those by right clicking on local package and selecting open, then choose structured file and open the .DTS file. Some companies do this to keep versioning and source control and actually check their .dts files into source control. This is a tad bit cleaner than just restoring another servers MSDB database to a new server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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