Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-02-08 : 07:58:55
|
| Dear All,I am having 100 of SQL jobs in sql server 2000 job instance.I need to migrate all these jobs to 2005 server instance.Please help me in this regard.Also i need to make relationship between 2 jobs in one sql jobs(i mean controlling of 2 sql jobs in one sql jobs)Pls help how to do it.Thanks,Ganagadhar |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 08:55:18
|
| script out from server and apply in 2005 serverhttp://msdn.microsoft.com/en-us/library/ms191450(SQL.90).aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 08:57:07
|
| or use transfer jobs taskhttp://msdn.microsoft.com/en-us/library/ms137568.aspx |
|
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
|
|
|
|
|
Migrating SQL Job from 2000 to 2005