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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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