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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-01-09 : 09:14:24
|
| Hi i've 2 different database one for 08 and one now for 09. what i like to do is copy the jobs that i have for 08 and point them to the 09 database. I still want to point the copyed job to the 08 database as i know i will need to reload some 08 data in the coming weeks. Is it possible to copy the job and then update it to point it to the new 09 database. Of course i will disable the 08 job untill i need it.The jobs contains about 20 stored porcedures there is no references to a dts package in the jobs.i've 4 jobs in total that i need to do this with. Any ideas ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-10 : 14:12:03
|
quote:
Originally posted by sodeep
quote:
Originally posted by visakh16
i think you need to use transfer sql objects task for thishttp://msdn.microsoft.com/en-us/library/ms142159.aspx
It's not available in DTS package. But same name as Copy SQL server object task.
Oh...just missed this is sql 2000 forum...thanks for the catch  |
 |
|
|
|
|
|
Copy the same job for different databases