Question

What happens if the ETL job fails in between? Should it be run manually again and if so will it start executing from the beginning.

Answer 1

• If the job is set to run periodically based on time internal, the job run automatically during the predefined interval
• Pentaho has a checkpoint to monitor and store the status of each successful execution step within a transformation and job, so the job will automatically skip over successfully executed parts of a job after a previously failed run