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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-22 : 08:31:07
|
| Vivian writes "Currently I am using SQL2000.I tried to schedule a DTS loading job on one of network servers. This loading package need export the data from this master server to another two network servers, and do the calculations on those servers. I expect the data export and calculation can be processed simultaneously. Is there any way I can schedule the job only on the master server?Thank you so much for your help!Vivian" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-22 : 09:57:25
|
| The answer seems a bit too simple ... yes, to schedule it only on the master server, schedule it only on the master server ?!?Care to clarify exactly the problem?Jay White{0} |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-22 : 17:39:54
|
| If you're looking for how to launch a DTS package on another server thenTake a look at BOL for linked servers and/or OSQLWhat you're looking for is under:"linked servers, access DTS package data source object"Edited by - ValterBorges on 10/22/2002 17:41:18Edited by - ValterBorges on 10/22/2002 17:42:12 |
|
|
|
|
|
|
schedule job