SQL Server Developer >> job history shows a failure even though the job succeeds
Hi,
SQL Server 2005 sp1.
I have a .NET utility (just an exe file) which does some work (scripting
using SMO) against sql server and generates an output to txt files.
When running the util manually it works ok.
When running the util via an sql agent job it works ok, this is determined
by the log file and the generated output.
However, the job history shows a failure as you can see in the bellow:
"The step did not generate any output. Process Exit Code 1. The step"