Pentaho Data Integration - Logging (#007)

Open the job created in the post #006; "jb_employees_incremental_load"

Right-click anywhere in the workspace/canvas and select "Job settings".

In the "Job properties" window go to the "Log" tab.

Log Connection: conn_oracle11g_orcl_dwh_dwh
Log schema: dwh
Log table: pentaho_log

Click "SQL" to create a log table.

Click "OK" and save your work.

Run the job and leave "Log level" as it is: "Basic logging"

Every event  seen in the "Logging" tab can be seen in the "log_field" column of the "pentaho_log" table.

SQL:
SELECT log_field FROM pentaho_log;

After logging table is ready Pentaho will show data in the "History" tab.

Some random example: