Please find Script Two below. It is the script which is responsible for calling the workflow in a loop.
Script two:
::
:: Project : INTERFACES
:: Purpose : Ensures that files are processed one by one if multiple files are present in source folder
:: Author : allispossibleteam
:: Date Started : 14 May 2010
:: Date Completed: 25 May 2010
:: Usage : loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
::
::@ ECHO OFF
SetLocal EnableDelayedExpansion
::
:: Interface Code (Received as parameter 1)
::
SET INTERFACE_CODE=%1
::
:: Workflow to execute (received as parameter 2)
::
SET WORKFLOW_NAME=%2
::
:: MAX number of files that will be allowed to be executed during one run of the bat file (RECEIVED AS PARAMETER 3) (SEND 0 [zero] FOR NO LIMITS)
::
SET MAX_NUM_OF_FILES=%3
::
:: Extension of source file (received as parameter 4)
::
SET EXTENSION_SOURCE_FILES=%4
::
:: INFORMATICA USERNAME, PASSWORWORD, SERVER IP, PORT NUMBER, FOLDER NAME CONTAINING MAPPING
::
SET INFY_USERNAME=Administrator
SET INFY_PASSWORD=Administrator
SET INFY_SERVER_IP=x.x.x.x
SET INFY_PORT_NUM=4001
SET INFY_FOLDER=XXXX
::
:: Path where log files are generated
::
SET PATH_OF_BATCH_FILE=E:\LOGS
::
:: Path containing the source file(s)
::
SET PATH_OF_SOURCE_FILES=E:\SOURCE_FILE
::
:: eXPECTED sOURCE fILE NAME FORMAT
::
SET SOURCE_FILE_NAME_FORMAT=%INTERFACE_CODE%_*.%EXTENSION_SOURCE_FILES%
::
:: Path for Temporary Folder where Source Files are copied
::
SET PATH_OF_SOURCE_FILES_TEMP=%PATH_OF_SOURCE_FILES%\TEMP_%INTERFACE_CODE%_CREATED_BY_BATFILE
::
:: Path and Name of Logfile
::
SET LOG_FILE=%PATH_OF_BATCH_FILE%\%INTERFACE_CODE%_LOOP_LOG.txt
::
:: Path for backup folder [Not used anymore - functionality disabled]
::
::SET BACKUP_FOLDER=%PATH_OF_SOURCE_FILES%\TEMP_BACKUP_%INTERFACE_CODE%_FILES_CREATED_BY_BATFILE
::
:: TO Allow workflow to execute even if previously it failed, PUT ANY OTHER CHARACTER EXCEPT CHARAcTER 'N'
::
SET ALLOW_WORKFLOW_TO_EXECUTE_WITH_PREVIOUS_STATUS_FAILED=N
::
:: To allow execution of workflow for other files even if workflow fails with one file, PUT ANY OTHER CHARACTER EXCEPT CHARAcTER 'N'
::
SET CONTINUE_EXECUTION_ON_WRKF_FAILURE=N
::
:: To enable prompting if overwriting an existing file in PATH_OF_SOURCE_FILES_TEMP, PUT ANY OTHER CHARACTER EXCEPT CHARAcTER 'N'
::
SET ENABLE_PROMPTING_IF_OVERWRITING=N
::
:: Time to wait (in Seconds) before startING workflow after file has been copied in the proper folder. This is to give sufficient time for file to be copied
::
SET TIME_TO_WAIT_B4_EXECUTING_WRKF=15
::
::====================== Set Variables above this line. Do NOT modify any code below this line. ==================================
::
::
:: Get todays date and place it in DAY, MONTH(numeric 01,02,03..12), MONTHN(Jan, Feb...Dec), YEAR(2007,2008, ...)
::
SET MYDATE=%date%
FOR /F "tokens=1-4 delims=/ " %%a in ("%MYDATE%") do (
SET DAY=%%c
SET MONTH=%%b
SET YEAR=%%d
)
SET TODAY=%YEAR%%MONTH%%DAY%
IF %MONTH%==01 SET MONTHN=Jan
IF %MONTH%==02 SET MONTHN=Feb
IF %MONTH%==03 SET MONTHN=Mar
IF %MONTH%==04 SET MONTHN=Apr
IF %MONTH%==05 SET MONTHN=May
IF %MONTH%==06 SET MONTHN=Jun
IF %MONTH%==07 SET MONTHN=Jul
IF %MONTH%==08 SET MONTHN=Aug
IF %MONTH%==09 SET MONTHN=Sep
IF %MONTH%==10 SET MONTHN=Oct
IF %MONTH%==11 SET MONTHN=Nov
IF %MONTH%==12 SET MONTHN=Dec
::
:: LOG START OF EXECUTION OF BATCH FILE AND ECHO TO SCREEN AS WELL
::
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Starting execution of batch file and hoping for its successful completion..............
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Starting execution of batch file and hoping for its successful completion..............
::
:: ERROR CHECK; Check if we have all required input parameters
::
IF %1.==. GOTO MISSING_PARAM_1
IF %2.==. GOTO MISSING_PARAM_2
IF %3.==. GOTO MISSING_PARAM_3
IF %4.==. GOTO MISSING_PARAM_4
::
:: ERROR CHECK; CHECK IF WORKFLOW HAD FAILED PREVIOUSLY
::
FOR /F "TOKENS=3 DELIMS=:[]" %%G IN ('pmcmd getworkflowdetails -s %INFY_SERVER_IP%:%INFY_PORT_NUM% -u %INFY_USERNAME% -p %INFY_PASSWORD% -f %INFY_FOLDER% %WORKFLOW_NAME% ^
find "Workflow run status:"') DO SET WORKFLOW_PREVIOUS_STATUS=%%G
IF %ALLOW_WORKFLOW_TO_EXECUTE_WITH_PREVIOUS_STATUS_FAILED%==N IF %WORKFLOW_PREVIOUS_STATUS%.==Failed. GOTO WORKFLOW_PREVIOUS_STATUS_FAILED
::
:: ERROR CHECK; CHECK IF SOURCE PATH EXISTS PATH_OF_SOURCE_FILES EXISTS
::
IF NOT EXIST %PATH_OF_SOURCE_FILES% GOTO PATH_OF_SOURCE_FILES_NOT_FOUND
::
:: cHECK IF PROMPTING REQUESTED B4 OVERWRITING FILE
::
IF %ENABLE_PROMPTING_IF_OVERWRITING%==N (
SET PROMPT_OPTION=Y
) ELSE (
SET PROMPT_OPTION=-Y
)
::
:: COPY ALL FILES FOUND IN PATH_OF_SOURCE_FILES TO PATH_OF_SOURCE_FILES_TEMP
::
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Moving All Files from %PATH_OF_SOURCE_FILES% to %PATH_OF_SOURCE_FILES_TEMP%
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Moving All Files from %PATH_OF_SOURCE_FILES% to %PATH_OF_SOURCE_FILES_TEMP%
FOR %%a in (%PATH_OF_SOURCE_FILES%\*.*) do (
>>%LOG_FILE% XCOPY "%%a" "%PATH_OF_SOURCE_FILES_TEMP%"\ /Z /I /H /K /%PROMPT_OPTION%
)
::
:: Delete copied Files
::
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting All Files in %PATH_OF_SOURCE_FILES%
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting All Files in %PATH_OF_SOURCE_FILES%
>>%LOG_FILE% DEL %PATH_OF_SOURCE_FILES%\*.* /Q
::
:: This variable counts total number of files loaded
::
SET TOTAL_FILES_LOADED=0
::
:: Used in case new files came in while the workflow was executing to allow the new files as well to be loaded. should be b4 the loop calling the workflow
::
:FOLDER_CHANGED_REDO
::
:: Call workflow for each file in directory PATH_OF_SOURCE_FILES_TEMP (HEART OF THE BAT FILE IS IN THIS LOOP, so handle with care please)
::
SET RETURNCODE=0
FOR %%a in (%PATH_OF_SOURCE_FILES_TEMP%\%SOURCE_FILE_NAME_FORMAT%) do (
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Moving any new Files from %PATH_OF_SOURCE_FILES% to %PATH_OF_SOURCE_FILES_TEMP%
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Moving any new Files from %PATH_OF_SOURCE_FILES% to %PATH_OF_SOURCE_FILES_TEMP%
SET FILE_COUNTER=0
FOR %%b in (%PATH_OF_SOURCE_FILES%\*.*) do (
>>%LOG_FILE% XCOPY "%%b" "%PATH_OF_SOURCE_FILES_TEMP%"\ /Z /I /H /K /%PROMPT_OPTION%
SET /a FILE_COUNTER=!FILE_COUNTER!+1
)
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting All Files in %PATH_OF_SOURCE_FILES%
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting All Files in %PATH_OF_SOURCE_FILES%
>>%LOG_FILE% DEL %PATH_OF_SOURCE_FILES%\*.* /Q
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] !FILE_COUNTER! new Files were found in %PATH_OF_SOURCE_FILES% and copied to %PATH_OF_SOURCE_FILES_TEMP%
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] !FILE_COUNTER! new Files were found in %PATH_OF_SOURCE_FILES% and copied to %PATH_OF_SOURCE_FILES_TEMP%
IF NOT !FILE_COUNTER!==0 GOTO FOLDER_CHANGED_REDO
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] About to move one file from %PATH_OF_SOURCE_FILES_TEMP% to %PATH_OF_SOURCE_FILES% and starting workflow
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] About to move one file from %PATH_OF_SOURCE_FILES_TEMP% to %PATH_OF_SOURCE_FILES% and starting workflow
>>%LOG_FILE% XCOPY "%%a" "%PATH_OF_SOURCE_FILES%"\ /Z /I
>>%LOG_FILE% DEL "%%a" /Q
:FILE_NOT_YET_DELETED
IF EXIST "%%a" GOTO FILE_NOT_YET_DELETED
CHOICE /T %TIME_TO_WAIT_B4_EXECUTING_WRKF% /D y
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Starting execution of workflow %WORKFLOW_NAME% with source file "%%a" ...
@ECHO Starting execution of workflow %WORKFLOW_NAME% with source file "%%a" ...
>>%LOG_FILE% pmcmd startworkflow -s %INFY_SERVER_IP%:%INFY_PORT_NUM% -u %INFY_USERNAME% -p %INFY_PASSWORD% -f %INFY_FOLDER% -nowait %WORKFLOW_NAME%
>>%LOG_FILE% pmcmd waitworkflow -s %INFY_SERVER_IP%:%INFY_PORT_NUM% -u %INFY_USERNAME% -p %INFY_PASSWORD% -f %INFY_FOLDER% %WORKFLOW_NAME%
SET RETURNCODE=!ERRORLEVEL!
IF ERRORLEVEL 1 IF %CONTINUE_EXECUTION_ON_WRKF_FAILURE%==N GOTO EXITLOOP
SET /a TOTAL_FILES_LOADED=!TOTAL_FILES_LOADED!+1
IF !MAX_NUM_OF_FILES! GTR 0 (
IF !TOTAL_FILES_LOADED!==!MAX_NUM_OF_FILES! (
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] MAX_NUM_OF_FILES[!MAX_NUM_OF_FILES!] has already been loaded. Exiting...
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] MAX_NUM_OF_FILES[!MAX_NUM_OF_FILES!] has already been loaded. Exiting...
GOTO EXITLOOP
)
)
)
::
:: Ensures cleanup scripts are executed in case of failure during execution of workflow
::
:EXITLOOP
::
:: ====================== FUNCTIONALITY REMOVED BELOW ==============================================================================================
::
:: DESC of OLD FUNCTIONALITY : Originally all files from source folder were being copied to the temp folder. After execution of the 'HEART' loop above,
:: if files remained in the temp folder, they were copied to a backup folder and the temp folder was deleted.
::
:: NEW FUNCTIONALITY: After execution of 'HEART' loop, if any files still remain in the temp folder, they are left there and the next time the interface is
:: is run, these files are run if they meet the proper file format
::
::
:: Copy any files remaining in %PATH_OF_SOURCE_FILES_TEMP% to %BACKUP_FOLDER%
::
::>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Copying any files remaining in %PATH_OF_SOURCE_FILES_TEMP% to %BACKUP_FOLDER%
::@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Copying any files remaining in %PATH_OF_SOURCE_FILES_TEMP% to %BACKUP_FOLDER%
::FOR %%a in (%PATH_OF_SOURCE_FILES_TEMP%) do (
::>>%LOG_FILE% XCOPY "%%a" "%BACKUP_FOLDER%"\ /Z /I /H /E /K /Y
::)
::
::
:: DELETING the DIRECTORY PATH_OF_SOURCE_FILES_TEMP
::
::>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting temporary directory %PATH_OF_SOURCE_FILES_TEMP%
::@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Deleting temporary directory %PATH_OF_SOURCE_FILES_TEMP%
::RMDIR /S /Q %PATH_OF_SOURCE_FILES_TEMP%
::
:: ====================== FUNCTIONALITY REMOVED ABOVE ==============================================================================================
::
::
:: cHECK IF ERRORS OCCURED DURING EXECUTION OF WORKFLOWS AND LOG CORRESPONDING ERROR
::
@ECHO RETURNCODE IS %RETURNCODE%
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] RETURNCODE IS %RETURNCODE%
IF NOT %RETURNCODE%.==0. GOTO LEVEL%RETURNCODE%
::
:: No Errors occured. Skip error logging
::
GOTO END_OF_SCRIPT
::
:: Error Logging in case required parameters are missing OR Workflow failed
::
:MISSING_PARAM_1
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 1; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 1; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
GOTO END_OF_SCRIPT
:MISSING_PARAM_2
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 2; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 2; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
GOTO END_OF_SCRIPT
:MISSING_PARAM_3
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 3; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 3; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
GOTO END_OF_SCRIPT
:MISSING_PARAM_4
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 4; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Missing Parameter 4; USAGE loopWorkflow.bat INTERFACE_CODE WORKFLOW_NAME MAX_NUM_OF_FILES EXTENSION_SOURCE_FILES
GOTO END_OF_SCRIPT
:WORKFLOW_PREVIOUS_STATUS_FAILED
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; %WORKFLOW_NAME% had failed in its previous run. To allow the workflow to execute even if the workflow had failed in its previous run, set the flag ALLOW_WORKFLOW_TO_EXECUTE_WITH_PREVIOUS_STATUS_FAILED to any other character except 'N' in the batch file.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; %WORKFLOW_NAME% had failed in its previous run. To allow the workflow to execute even if the workflow had failed in its previous run, set the flag ALLOW_WORKFLOW_TO_EXECUTE_WITH_PREVIOUS_STATUS_FAILED to any other character except 'N' in the batch file.
GOTO END_OF_SCRIPT
:PATH_OF_SOURCE_FILES_NOT_FOUND
@ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The path %PATH_OF_SOURCE_FILES% was not found!!!
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The path %PATH_OF_SOURCE_FILES% was not found!!!
GOTO END_OF_SCRIPT
:LEVEL1
@echo The PowerCenter Server is down, or pmcmd cannot connect to the PowerCenter Server. The TCP/IP host name or port number or a network problem occurred.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The PowerCenter Server is down, or pmcmd cannot connect to the PowerCenter Server. The TCP/IP host name or port number or a network problem occurred.
GOTO END_OF_SCRIPT
:LEVEL2
@echo The specified task name, workflow name, or folder name does not exist.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The specified task name, workflow name, or folder name does not exist.
GOTO END_OF_SCRIPT
:LEVEL3
@echo An error occurred in starting or running the workflow or task.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; An error occurred in starting or running the workflow or task.
GOTO END_OF_SCRIPT
:LEVEL4
@echo Usage error. You passed the wrong parameters to pmcmd.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Usage error. You passed the wrong parameters to pmcmd.
GOTO END_OF_SCRIPT
:LEVEL5
@echo An internal pmcmd error occurred. Contact Informatica Technical Support.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; An internal pmcmd error occurred. Contact Informatica Technical Support.
GOTO END_OF_SCRIPT
:LEVEL6
@echo An error occurred while stopping the PowerCenter Server. Contact Informatica Technical Support.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; An error occurred while stopping the PowerCenter Server. Contact Informatica Technical Support.
GOTO END_OF_SCRIPT
:LEVEL7
@echo You used an invalid username or password.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; You used an invalid username or password.
GOTO END_OF_SCRIPT
:LEVEL8
@echo You do not have the appropriate permissions or privileges to perform this task.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; You do not have the appropriate permissions or privileges to perform this task.
GOTO END_OF_SCRIPT
:LEVEL9
@echo The connection to the PowerCenter Server timed out while sending the request.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The connection to the PowerCenter Server timed out while sending the request.
GOTO END_OF_SCRIPT
:LEVEL12
@echo The PowerCenter Server cannot start recovery because the session or workflow is scheduled, suspending, waiting for an event, waiting, initializing, aborting, stopping, disabled, or running.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The PowerCenter Server cannot start recovery because the session or workflow is scheduled, suspending, waiting for an event, waiting, initializing, aborting, stopping, disabled, or running.
GOTO END_OF_SCRIPT
:LEVEL13
@echo The username environment variable is not defined.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The username environment variable is not defined.
GOTO END_OF_SCRIPT
:LEVEL14
@echo The password environment variable is not defined.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The password environment variable is not defined.
GOTO END_OF_SCRIPT
:LEVEL15
@echo The username environment variable is missing.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The username environment variable is missing.
GOTO END_OF_SCRIPT
:LEVEL16
@echo The password environment variable is missing.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The password environment variable is missing.
GOTO END_OF_SCRIPT
:LEVEL17
@echo Parameter file does not exist.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Parameter file does not exist.
GOTO END_OF_SCRIPT
:LEVEL18
@echo The PowerCenter Server found the parameter file, but it did not have the initial values for the session parameters, such as $input or $output.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The PowerCenter Server found the parameter file, but it did not have the initial values for the session parameters, such as $input or $output.
GOTO END_OF_SCRIPT
:LEVEL19
@echo The PowerCenter Server cannot start the session in recovery mode because the workflow is configured to run continuously.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The PowerCenter Server cannot start the session in recovery mode because the workflow is configured to run continuously.
GOTO END_OF_SCRIPT
:LEVEL20
@echo A repository error has occurred. Please make sure that the Repository Server and the database are running and the number of connections to the database is not exceeded.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; A repository error has occurred. Please make sure that the Repository Server and the database are running and the number of connections to the database is not exceeded.
GOTO END_OF_SCRIPT
:LEVEL21
@echo PowerCenter Server is shutting down and it is not accepting new requests.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; PowerCenter Server is shutting down and it is not accepting new requests.
GOTO END_OF_SCRIPT
:LEVEL22
@echo The PowerCenter Server cannot find a unique instance of workflow/session you specified. Enter the command again with the folder name and workflow name.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; The PowerCenter Server cannot find a unique instance of workflow/session you specified. Enter the command again with the folder name and workflow name.
GOTO END_OF_SCRIPT
:LEVEL23
@echo There is no data available for your request.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; There is no data available for your request.
GOTO END_OF_SCRIPT
:LEVEL24
@echo Out of memory.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Out of memory.
GOTO END_OF_SCRIPT
:LEVEL25
@echo Command is cancelled.
>>%LOG_FILE% ECHO [%DAY% %MONTHN% %YEAR% %TIME%] Execution ABORTED; Command is cancelled.
GOTO END_OF_SCRIPT
:END_OF_SCRIPT
::
:: Draw a line in log file to seperate it from logs of next run
::
>>%LOG_FILE% ECHO ===========================================================================================================================================================
EndLocal
@ ECHO ON
No comments:
Post a Comment