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

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” on page 38, then go to step 8.