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