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.
Click to hear an audio file of the anti-spam word

 
  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