Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: How to 'Save As' an exisitng Job into a new job

    Is there a "Save As" facility in MS SQL Jobs just like in DTS Packages? I need to create a new job that has almost the same steps in the exisitng job. Creating a new job is tedious, how can i simply copy the existing job and save it as a new job?

    Thanks.

  2. #2
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Not really save as but you can generate the script for the job (right click on the job->All tasks->Generate Script), open it in QA, change the job name and modify the steps to meet your new job's requirements. Run it and it'll create the new job for you.

  3. #3
    Join Date
    Oct 2005
    Posts
    119
    wow! i learned something new. that's a great help. thanks a lot!

  4. #4
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Quote Originally Posted by LimaCharlie
    wow! i learned something new. that's a great help. thanks a lot!
    You're welcome. Seems like there is always something new to learn, no matter how long you've been in the business.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •