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