Search code examples
batch-filepentahojobskettle

running multiple jobs from a batch file in pentaho


I would like to ask if there is a more efficient way of running multiple transformations(70 transformations) besides the IDE? Doing it the IDE way is alright but it does become tedious having to click all the tabs and the hidden tabs as well.

What I did was I tried using the pan.bat command and placed it in a bat file. The bat file would look like this:

cd <to dest of kitchen.bat>

pan.bat <mytransformation 1>
pan.bat <mytransformation 2>
pan.bat <mytransformation 3>
pan.bat <mytransformation 4>

But it only works on the first transformation and then it quits. Am I doing something wrong or what options do I have to run multuple transformations from script


Solution

  • When calling a batch file from another, you have to use the call command, otherwise (as you found) it transfers control to the new batch file permanently.

    call pan.bat <mytransformation 1>
    call pan.bat <mytransformation 2>
    call pan.bat <mytransformation 3>
    call pan.bat <mytransformation 4>