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 |
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-02-08 : 11:16:02
|
how do I create a script to run a job so that it copies the data from live to the UAT sql server?Thanks |
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-02-08 : 11:23:09
|
read up in BOL on 'sp_start_job'maybe you would create a DTS to do the data transfer??You could create a job that runs the DTS, and then start it using sp_start_jobCorey"If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain |
|
|
|
|
|