April 22, 2003 at 12:09 pm
Is there a way to copy and rename a job? I have a job with 60+ job steps, schedule, and notifications and I need to copy and rename it and make minor modifications.
April 22, 2003 at 1:16 pm
If anybody is interested, I found a way to do this. First, script the job you want copied. Then modify the script by replacing the original job name with the new job name. Then create a new DTS with a conection to the msdb database and 'generate SQL task' by getting the script. Execute the DTS and the new job exists.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy