Operational metadata are stored in the following Teradata PT predefined private logs for each job:
Using the data schema described in “Viewing Metadata” on page 254, operational metadata from these logs can be loaded into Teradata tables for SQL access. Use the scripts supplied in the Samples directory that is installed with Teradata PT. The script samples include instructions.
SQL examples for extracting operational metadata from Teradata tables are also stored in the Teradata PT Samples directory as follows:
Each of the SQL files also provides examples for using an SQL join to extract combined metadata results from the operational metadata tables.