SQL and Result Status in the View Log File - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
the1488824663377.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2512
Product Category
Teradata Tools and Utilities

Teradata Query Scheduler writes the SQL and result status of a scheduled request to the View log file. The result status includes the rows processed, elapsed time, and error messages (if any occurred). A different View log file is created for each Job ID for the scheduled request.

A scheduled request defined to execute daily causes a separate View log with Job ID to be created every day to log results and error messages created by that request. For example, "ViewLog_JobID 1365448" might contain:

SELECT * FROM DBC.DBCINFO 
3 rows returned.  Total elapsed time was 00:00:00 (hh:mm:ss).