September 19, 2011 at 8:32 pm
Hi I have one big SQL 2005 instance with 200 sql agent jobs I need to move to another instance. Is there a quicker way then right clicking each individual job--> script job as-->create to.
I thought I could google some kind of script and extract the jobs out of msdb or something.
I also have another large SQL 2000 instance I need to migrate too.
Thanks!
September 19, 2011 at 8:44 pm
You can do the same. Click on 'Jobs' underneath SQL Server Agent on the management studio.
On the right side you should see a tab called 'Object Explorer details'. Select all->Right click and script.
Regards,
Raj
September 19, 2011 at 9:13 pm
I owe you a beer! Thanks!
September 20, 2011 at 10:22 am
Theres also an SSIS task to do this which works quite well
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2011 at 10:54 am
You can select all jobs at once (from SSMS) and script them out.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply