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

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

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).