Archives of the TeradataForum

Message Posted: Thu, 04 Sep 2003 @ 15:14:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, September 04, 2003 11:07 -->

In our environment the Windows (2000) based load utilities are being called by our automated job scheduler via a batch file. This works well in all cases where the load completes successfully. In the event of a failure, the return code from the utility is not being bubbled up to the job scheduler.

How can I capture the return code from inside the batch file to pass it back to the job scheduler. I have tried the following with no success:

@SET E=0

FEXP.EXE < X:\SCRIPTS\BADEXPORT.txt

IF ERRORLEVEL 0 GOTO EXIT

SET E=ERRORLEVEL

:EXIT
EXIT /B %E%

Any suggestions?

	<Prev	Next>		<<First	<Prev	Next>	Last>>