dbTalk Databases Forums  

Start and stop a Windows Serrvice on a Remote machine

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Start and stop a Windows Serrvice on a Remote machine in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
LP
 
Posts: n/a

Default Start and stop a Windows Serrvice on a Remote machine - 10-27-2005 , 08:10 AM






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

Reply With Quote
  #2  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: Start and stop a Windows Serrvice on a Remote machine - 10-31-2005 , 08:43 AM






LP,

Rsh or Rexec will execute commands locally on remote machines. Look them up
in the Windows help.

Ilya

"LP" <LP (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.