How to get job history/error info. from a custom .exe being run by the job?
We're using SQL Server 2005 and SQL Server Agent to run some jobs. These jobs execute a custom .exe program (written in C#).
What we're wondering is, is there any way to send status/history information from the custom .exe back to the job that kicked it off?
We're trying to provide execution info. to show if the job succeeded or if some error occurred in the .exe (thus the job didn't complete successfully).
Thanks!
Have the custom app logs to a file then when the job exits, load the logs/histories into a sql table.
No comments:
Post a Comment