Pentaho

 View Only

 DDL or similar definition file to create the tables for job and transformation logs

stefan Ostman's profile image
stefan Ostman posted 02-21-2024 01:25

Hi

Trying to setup the logging to database for jobs and transformations. Are there any data type definitions (eg. a DDL-file) to download from anywhere or is it just trial and error that is the only way to get it right. 

Tobias Kuhrke's profile image
Tobias Kuhrke posted 02-22-2024 09:25
In Job or Transformation Properties go to Logging tab, fill connection and table name and click the "SQL" Button and you'll get the statement or execute it directly.
Petr Prochazka's profile image
Petr Prochazka posted 02-23-2024 05:09

Hi Stefan,

logging setttings is in trans/job properties dialog.

In tab Logging select type of logging and fill required parameters. And click on SQL button below.

Related Content