Example: Using QryLogUtilityV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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