Create Process on Remote Machine

[MNfox]

Hi all,
I am new here.

I have question about how to create a process on a remote machine (execute an EXE program on a remote machine).

Basically, I have a Manager program and a Parser program. The manager connect to a SQL server, grab records, and creates HTM files (written to a network drive). After all that, it will execute the Parser.exe on a different machine.

I am using psExec in psTools at

http://www.sysinternals.com

to execute the Parser on the remote machine. I just wonder if I can do all that in VFP 6 without using any third party software or utility. I've read most of the threads about CreateProcess, CreateProcessAsUser, CreateProcessWithLogonW, WinSock,... but nothing really can handle my problem.

All help will be appreciated, and thank you in advance
Smurf

 

[baltman]

Run a program/form/app using a timer to check a folder for a file with instructions...

http://www.lespinter.com/PC/ShowArticle.aspx?ArtNum=215

You can even create your own service which would start whenever the server booted independent of login... search for srvany.exe (which is development platform independent).

Brian

 

[MNfox]

Thanks Baltman for your post.

I've already had several different apps running 24/7 to monitor files, and few machines running services which can be triggered remotely.

The reason I go for this route is that I don't want this to be machine dependent. The Manager will decided how many parser machines it needs to parse all the records it pulled from the SQL server. Sometimes, it needs up to 20 servers, and I don't want some apps running 24/7 on all 20 servers, or install services in all 20 servers for this task.

We have a list of servers which the Manager program can use. The servers are changed from time to time (to production or to DEV) and that is why I want to go for this route.

MNfox

PS: please excuse me for my English, since it's my second language.