17.00 - Example: Using QryLogUtilityV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The following SELECT statement retrieves the start time, end time, and row counts for FastLoad or TPT Load jobs submitted by USER1 since December 1, 2013:

SELECT UtilityName, LSN, JobStartTime, JobEndTime, RowsInserted
FROM DBC.QryLogUtilityV
WHERE UserName = 'USER1'
 AND (UtilityName = 'FASTLOAD' OR
      UtilityName = 'TPTLOAD')
 AND JobStartTime > DATE '2013-12-01'
ORDER BY JobStartTime;

Result:

UtilityName LSN JobStartTime               JobEndTime                 RowsInserted
----------- --- -------------------------- -------------------------- ------------
FASTLOAD    47  2013-12-02 09:19:22.150000 2013-12-02 09:30:59.670000 100,000
FASTLOAD    48  2013-12-02 09:19:24.250000 2013-12-02 09:30:44.820000 100,000
TPTLOAD     54  2013-12-02 10:07:41.700000 2013-12-02 10:07:48.940000 81,920