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

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2512
lifecycle
previous
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).