December 7, 2009 at 11:23 am
Hi guys, can some body give me step by step process to Transfer all the SQL Agent jobs from 2000 to 2005
December 7, 2009 at 11:28 am
Do the create scripts not work?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 7, 2009 at 11:28 am
Many jobs or just a Single job?
Side by Side upgrade to SQL 2005?
One option could be Redgate Data Compare - and compare the MSDB database (sysjobs,sysjobschedules, sysjobsteps, sysjobservers, sysjobhistory).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 11:35 am
Easiest way to do this is through an SSIS package. Just open SQL Server Business Intelligence Development Studio, open new integration package, from your toolbox, drag / drop Transfer Jobs Task, double click, specify instances and run it.
December 7, 2009 at 12:04 pm
the servers are not side by side, wht I did was, Selected all jobs(ctrl+A)->Rt.Click on it-> open script. Copied this script and executed on SQl 2000 server, but I can not see all the jobs transferred. My work is first I have to get all jobs from sql production 2000 server to sql test 2000 server and then tranfer to 2005 TEST server.
December 7, 2009 at 12:17 pm
sureshdeenu (12/7/2009)
the servers are not side by side, wht I did was, Selected all jobs(ctrl+A)->Rt.Click on it-> open script. Copied this script and executed on SQl 2000 server, but I can not see all the jobs transferred. My work is first I have to get all jobs from sql production 2000 server to sql test 2000 server and then tranfer to 2005 TEST server.
As a check on the Target sql2k server, run the following and see if you get results
Select Originating_Server, [Name],Enabled,[Description]
From msdb.dbo.sysjobs
Do any of those results match the Jobs of the Source server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 12:26 pm
yes, I see 19 rows on the sql 2000 dest server, but i run the same query on sql 2000 source, it shows 71 rows. so It seems to me all the jobs has not been transferred
December 7, 2009 at 12:28 pm
Do you see commonality between the ones that were successful versus those that were not successfully transferred via your script?
Also, have you checked your script to see that the 71 not transferred were included in your script? When you ran the script, did you encounter any errors?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 9, 2009 at 7:23 am
Forgot to move the Operators first, i got it. once I run the script for Operators, then I ran the script for Jobs. All jobs are copied on the destination server. Thanks for all your support guys
December 9, 2009 at 8:48 am
You're welcome and thanks for the feedback.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply