Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rob41
Yak Posting Veteran
67 Posts |
 Posted - 2010-05-24 : 10:39:32
|
| I have set up a job in sql server agent that has 70 steps (individual queries). I would like to duplicate this job and change various jobs to be used in the future. Is there a way to copy my original job and save it as a new job. For example my job is Process_all inbound and I want to copy that and save it as Rename_certain inbound.Thanks as always for any suggestions and help |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-05-24 : 23:50:39
|
| I feel that you can generate and execute the script and use new name for the job.Thereafter you can change the steps from Enterprise manager / SSMS. |
 |
|
|
zstarsales04
Starting Member
20 Posts |
Posted - 2010-05-25 : 02:16:32
|
| spam removed |
|
|
|
|
|
|
how to copy sql server agent jobs