![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hello All, I have a windows service on several remote machines that gather data and load it to SQL 2000. The service on the remote machine runs at a desirable frequency and gathers the data. I'm using DTS on a central server to bring the data back. The DTS package has it's own schedule and all works well. But now I want to "on demand" runs the service on a particular machine to collect up to the minute information. From the DTS package I'm planning to use an Execute Process Task to restart the remote service so it. I know how to start and stop a Windows service on a local machine but have not done it remotely. Anybody ever done this before? Thanks, LP |
![]() |
| Thread Tools | |
| Display Modes | |
| |