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?
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.