>I am running a set of steps from within a SQL Server Job. The very last step is to execute a VFP EXE. I am using something like:
>
>'D:\My Directory\SubDir\myapplication.exe'
>
>as the last step of the job (replace single-quotes with double-quotes in the line above). The job, upon reaching this step, does not continue any further. It does not report a failure, but the EXE does not execute. I have to manually stop the job. I am writing to a status.txt from within the VFP EXE to see how far it has progressed, but the EXE does not even reach line 1.
>
>I replaced the exe with a system command (like dir > status.txt) and that works. Is there some sort of problem with VFP apps and SQL Server?
>
>Thank you.

A few things that come to mind:
-Have you loaded the VFP runtime files to your server?
-Can the executable find all files (dbc, dbf, etc.) that it needs to do its work? Running an exe from a job has a startup directory of c:\%windir%\system32 by default.
-Does the account id that the job runs under have the permissions to the required files that the exe is trying to open?

Something that might help is logging the error message from VFP to a text file. That is, if the problem is not related to permissions.