Kettle Pan & Kitchen Template

Kitchen_.bat

@echo off
SET JAVA_HOME=C:\Program Files\Java\jre1.8.0_281
SET PATH=%PATH%:%JAVA_HOME%\bin
SET TGL=%DATE:~-4%%DATE:~3,2%%DATE:~0,2%
SET JAM=%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
SET KTR_DIR=C:\OnGoing\
Kitchen.bat /norep /file=%KTR_DIR%\Test.kjb /logfile=%KTR_DIR%\logs\Test_%TGL%_%JAM%.log

Pan_.bat

@echo off
SET JAVA_HOME=C:\Program Files\Java\jre1.8.0_281
SET PATH=%PATH%:%JAVA_HOME%\bin
SET TGL=%DATE:~-4%%DATE:~3,2%%DATE:~0,2%
SET JAM=%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
SET KTR_DIR=C:\OnGoing\
Pan.bat /norep /file=%KTR_DIR%\Test.ktr /logfile=%KTR_DIR%\logs\Test_%TGL%_%JAM%.log

• Check your java version, add JAVA_HOME path
• Include JAVA binary directory to PATH
• Set DATE & TIME format
• Replace KTR_DIR with your working directory
• Replace file jobs & transformations
• Replace logs directory
• Run this command from your KETTLE_HOME