January 30, 2008 at 9:34 am
Is there a script that enable the copy of specific sql server agent jobs from one database to another. Thanks for your help in advance....
January 30, 2008 at 10:48 am
How about right clicking in SSMS and then selecting "Script Job as" and "Create to" to arrive at a script that completely replicates the job, schedule and all.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 30, 2008 at 3:37 pm
yaa Grant Fritchey suggestion is the best thing which i also have to suggest.
cheers
sreejith
MCAD
January 31, 2008 at 8:29 am
Yeah. That worked great. Thanks guys....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply