Bryan Feeser
SSC Veteran
Points: 206
More actions
December 8, 2005 at 9:24 am
#90089
I want to copy a SQL Server Agent Job from one server to another. Is there an easy way of doing this?
Ray M
SSC-Insane
Points: 21093
December 8, 2005 at 10:34 am
#608481
In Enterprise manager.
Right click on the job, select all tasks Generate SQL script
Jonathan Stokes
SSCrazy Eights
Points: 9861
December 12, 2005 at 7:37 am
#608998
Additionally you can use the 'Transfer sql server job' task using dts. That way you can tick the boxes to copy over multiple jobs in one go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply