How to schedule Pentaho Kettle transformations?

Question

I've set up four transformations in Kettle. Now, I would like to schedule them so that they will run daily at a certain time and one after the another. For example,

tranformation1 -> transformation2 -> transformation3 -> transformation4

should run daily at 8.00 am. How can I do that?

Answer 1

There are basically two ways of scheduling jobs in PDI.

1. You can use the command line (as correctly written by Anders):

for transformation scheduling: <pentaho-installation directory>/pan.sh -file:"your-transformation.ktr"

for job scheduling: <pentaho-installation directory>/kitchen.sh -file:"your-transformation.kjb"

2. You can also use the inbuilt scheduler in Pentaho Spoon.

If you are using the EE version of PDI, you will have a inbuilt scheduler in the spoon itself. Its an UI interface which you can use it to easily schedule jobs. You can also read this section of doc for more.