Rem How to run
Rem the 3rd arg for the bat will be the data file name pattern
Rem the 2nd args for the bat is the DATE

@ECHO off
SET “configfile=C:\Batch\scripts\dbconn.daz”
SET “logfile=C:\Batch\Logs\%1%_%2%.log”
SET “ClientPath=C:\Oracle\product\11.2.0\client_1\BIN”

IF NOT EXIST %configfile% GOTO ExitLogInError

REM IF NOT EXIST %datafile% GOTO ExitError

SET /p connstr= <%configfile%

ECHO @C:\Batch\scripts\etl_task.sql %1 %2 %3 | %ClientPath%\sqlplus %connstr% > “%logfile%”
REM findstr /c:”FAILURE” “%logfile%” >nul 2>&1 && echo “run time failure” || echo “run success”
findstr /c:”(FAILURE)” “%logfile%” >nul 2>&1 && GOTO  Exit_failure || GOTO Exit_Success
:Exit_Success

SET ERRORLEVEL=0
ECHO “Success!
GOTO Exit_last

:Exit_failure

SET ERRORLEVEL=3
ECHO “Failure”
Exit 3

:ExitLogInError
ECHO config File %configfile% does not exist
EXIT 1

:Exit_last

ECHO “Exit code is %ERRORLEVEL% for this run”

—-

–set term off echo off heading off verify off
–exec user.PKG_Trans_Archiving.ArchiveTransactions(‘&1’,to_date(‘&2′,’yymmdd’));
set serveroutput on;
EXEC ETL_RUN_TASK.run_task(‘&1′,’&2′,’&3’);
exit;