Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kitchen in Windows CMD

  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Default Kitchen in Windows CMD

    Hello everyone,

    I'm trying to schedule a couple of commands, including kitchen.
    First, I delete some tables from oracle using the command
    "sqlplus username/password @C:\Documents....\test.sql"

    after that, I do a couple of these commands using sqlplus, access, ....

    Everything works fine untill the point where I start using Kitchen.

    Kitchen needs to update my dimensions, so I start the job "JOB_ALL.kjb" using the command

    kitchen.bat /file:JOB_ALL.KJB

    Everything goes well, but when all the dimensions are updated, the CMD just stops. The other commands after the Kitchen command aren't being executed. It appears that Kitchen stops the CMD from doing anything (executing other commands) AFTER the Kitchen command.


    Does anyone have a solution for this problem?

  2. #2
    Join Date
    Oct 2011
    Posts
    1

    Default

    I realize this post is really old, but if anyone else has this problem, it is not actually a problem with kitchen. When calling a batch file from another batch file, you have to use the function "call".

    So instead of
    Code:
    kitchen.bat /file:JOB_ALL.KJB
    you need
    Code:
    call kitchen.bat /file:JOB_ALL.KJB
    If you don't do this Windows sees the end of the batch file you are are calling as the end of the entire batch file you are writing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.