A VFP app (exe) is called by the SQL Server job scheduler (agent).

If the application for one reason or another terminates unexpectedly (bombs), it should send a return code to the SQL Server agent informing it of the event.

While VFP will write an error message to it's own log (my logging function) before quitting, when looking in the SQL Server activity log, it seems that the agent is not informed of this event and thinks it terminated normally.

Any suggestions and / or solutions are greatly appreciated.