17.10 - Example: Using QryLogUtilityV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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