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