Use the following procedure to drop the results table or file associated with the selected request or job. Dropping results cleans up tables or files generated for that request or job.
To use the same results table or file for each request, the results must be dropped. Also, either the Drop if exists or Append if exists options can be used when scheduling requests. For more information, see “Scheduling a SQL Request” on page 38.
1 From the Teradata Query Scheduler Viewer, select a job from the Jobs list.
2 Click Options > Drop Results or right-click the request to display a shortcut menu and click Drop Results.