RSS
 

Pentaho Kettle Scheduled Task: Windows

08 Jul

To run a Spoon/Kettle job from the command line (convenient for creating a scheduled task) use the following syntax:

kitchen.bat /rep:”REPOSITORY NAME” /job:”JOB NAME” /dir:/LOCATION /user:USER_NAME /pass:PASSWORD /level:Basic

Replace /job: with /file: to run a job from a file if you’re not using a repository.

 
3 Comments

Posted in RIA

 

Leave a Reply

 

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Anti-spam image

 
  1. Alexander

    July 9, 2010 at 7:02 am

    It wouldn`t work! Between parameter and value must be space:

    kitchen.bat /rep: ”REPOSITORY NAME” /job: ”JOB NAME” /dir: /LOCATION /user: USER_NAME /pass: PASSWORD /level: Basic

     
    • Alexander

      July 9, 2010 at 7:08 am

      Sorry, I`m wrong.
      However if you want to execute it throught .bat file you want to change directory first. Like that:

      cd “C:\Program Files\data-integration_3.2.5\”
      kitchen.bat /rep: ”REPOSITORY NAME” /job: ”JOB NAME” /dir: /LOCATION /user: USER_NAME /pass: PASSWORD /level: Basic

       
  2. Joshua

    July 9, 2010 at 10:43 am

    Alexander,
    Yes you’ll want to specify the ‘Start In’ folder for the scheduled task or ensure (via batch or the PATH) that everything can be resolved (like you’re suggesting).

    Cheers
    Josh