Pierre Ammoun
asked on
Run Executable remotely based on a "trigger" from a client PC
I have created a serie of executable files that each generate a specific report on the server.(Visual Foxpro 9).
I need to enable the user , but doing something (send an email., copy a file to a folder, do anything that will trigger that executable file.
I can not give him access to the server. and there are many executables.. (around 20)
I was thinking of creating a watchdog on a folder... but don't know how to do this in Visual Foxpro
I need to enable the user , but doing something (send an email., copy a file to a folder, do anything that will trigger that executable file.
I can not give him access to the server. and there are many executables.. (around 20)
I was thinking of creating a watchdog on a folder... but don't know how to do this in Visual Foxpro
An outlook rule would do that.
You mentioned "copy a file to a folder" as a possible trigger. You could create a simple "watcher" program in VFP (or whatever language) to check for the existence of that file periodically and run a report when it finds the file. You could specify which report to run by giving the file a different name for each, or by putting the report name in the file. The watcher program could run constantly on the server, using its own built-in timer to determine when to check for a file, or it could be started by the Windows Task Scheduler on whatever schedule you set up.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I can not give him access to the server does not creating a file on the server imply some sort of access?
This should be OK when your data are on SQL Server. Users or better said the local application can have access to the Print queue on SQL Server only. The printing program has also access to the same printing queue and to the data which are reported.
You may even install the free SQL Express on the Server for this purpose. The password can be known to the local application only etc. etc.
You may even install the free SQL Express on the Server for this purpose. The password can be known to the local application only etc. etc.
https://docs.microsoft.com/en-us/sysinternals/downloads/psexec