16.20 - Saving Result Data - 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

Most scheduled requests, especially automatically scheduled requests, are not self-contained; that is, they do not specify where to save the results data. Using Teradata QS the results for those types of requests can be saved. However, results from only the last statement in the scheduled request are saved. To do this, the last statement in your scheduled SQL request must be a SELECT statement, and a valid Teradata Database and table or a valid Teradata QS server file name in which to store the results must be specified.

If the results table or file already exist when the scheduled request is run, one of the following events occurs:
  • The job execution is aborted and the job is marked as failed.
  • The results table is destroyed, if so specified. Then, the results table is recreated with the proper column types and the data from the last statement is stored.

Which event occurs depends on your selections in the Results tab of the Teradata Query Scheduler Submit Request dialog box. To find out how to make these selections, see Scheduling a SQL Request, then go to step 8.