Pentaho

If you install PDI in the server, you just call the kitchen.sh with the job file and parameters if needed. To run a transformation you use the pan.sh script. Look in Pentaho documentation the parameters you can pass to kitchen and pan scripts.

Thank you Ana for your suggestion, I will try it.

However I've seen that on the server there are already some schedules that are using a .xaction file.

I've downloaded this file that is a zip file that includes three files: a file .xaction, a file .xaction.local and a file called exportManifest.xml.

In these files there are some references to the job.

I've duplicated and renamed this file, changed the references to the job, created the new zip file and imported it.

Now it seems that the new chedule works,

I don't know if the production of this .xaction file can be automated.

Claudio

I can't help you there, I don't use the server to schedule the execution of PDI jobs and transformations, maybe you can find something in the old forum (https://forums.pentaho.com/) or in old blog posts, Diethard's blog has a lot of useful information in PDI: https://diethardsteiner.github.io/list.html

You can login the user console, upload the files (kjb, ktr), then schedule from the browse files dialog.

You can control the execution accesing the kettle status at pentaho/kettle/status