A job executes a procedure on SQL Server, in which controlm sysout log is successful, but the command execution of the job creates an external logfile which has actually failed.
In this situation the job should be alerted as failure.
Any ideas or help?