If you want to get started quickly or do not have information about your email server, skip this for now. Setting up an email server is not required. This feature works with the report scheduling feature to automate the process of emailing reports to your user community. Resulting into lesser response time and making job running again from failure point in short duration of time with greater accuracy.Īlso,The convenient way to share reports is to set up an email server that can send reports to recipients. Solution to this problem is by sending an email notification which will provide information related to running status of a job and send email in case of failure occurs. While monitoring these complex jobs it may gets error prone.
So while monitoring job execution manually we need to keep close look at the log file, Which is tedious task. As if job is scheduled to run at predefined time slot it may gets failed due to Data, Network or Database related issues. Hence this was all about creating a batch file to run a scheduled Pentaho transformation.Most of real time production level Pentaho ETL job are of complex design which will result into run time failures. Give your directory where the batch file is stored in the action tab.
Now give your start time and end time along with the option of running it on daily, weekly or monthly basis. Also, select whether the Program should run while a user is logged on or when he is not. In general, category gives the Name of your Task and also the description if you need to.
Now follow the underlying process to create a Task in the Windows Task Scheduler: Now your batch file is ready which needs to be scheduled now according to the user’s requirement. The 2 nd line takes you to the directory where your local Pentaho Data Integration is stored which is then followed by calling the Pan program with the transformation path. Pan.bat /rep:Repo /user:user /pass:password /dir:home/Pentaho /trans:SF_GetAccounts
The following code illustrates the same:Ĭd /d”C:\Pentaho\design-tools\data-integration” Once you are done with this transformation our next aim is to create a batch file that runs on top of this batch file.
Try to run the same and you should very well be able to run the given transformation. Here we have defined the path where the Pan batch file is located and then we have written the script which calls that particular transformation getting into the repository and to that particular directory where our transformation is stored. :password /dir:home/Pentaho /trans:SF_GetAccounts Go to command line and write the following code which will execute the transformationĬ:\Pentaho\design-tools\data-integration>Pan.bat /rep:Repo /user:user /pass For that Pentaho provides us with a Pan application which is a program that can execute transformations designed in the spoon when stored as a KTR file or in a repository. Windows Task Scheduler where we will schedule a batch file that runs on top of Pan.batch for a given transformation.įirst and foremost we need to create the script that would run the specified transformation through a command line. In this blog, we are going to discuss about scheduling a given transformation through
HOW TO CREATE A BATCH FILE TO RUN A SCHEDULED PENTAHO TRANSFORMATION