Copying Jobs

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

  • 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