August 27, 2010 at 4:33 am
Hi,
I have cretaed more than 50 jobs in a server but i need to move all the jobs from one server to another server. is there any possibilities to do without doing manually .
Please help to slove this issues
Thanks in Advance!
Sabarinathan
August 27, 2010 at 5:21 am
Well, if you have Management Studio (SSMS), then you can script them! (what a wonderful world).
Go to SSMS, make sure you have the object explorer details window open and then go to your jobs. Select them all in the details window and right-click on them. Select Script Job As..., then Create To and finally select the destination of the script.
I would advise them to put each create job script in a different file. The scripts use transactions with go to statements, so if one fails, you could be in trouble. Just separate them and execute them sequentially.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply