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.
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
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