>>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.

I tried all that. My problem was that I did not have the correct syntax.
I was using:
'D:\My Directory\SubDir\myapplication.exe'

Instead of:
cmd /c 'D:\My Directory\SubDir\myapplication.exe'