The Query Operations push button on the Result Set window allows
you to drop result tables and cancel individual queries and recurring
queries. Clicking Query Operations displays the Query
Operations window. The Query Operations window is illustrated
below:
You can drop a result table for an individual query, or for all queries with the same schedule ID. To drop a result table for a specific job, click the radio button labeled Drop result table with job ID <jobID>, and click OK.
To drop the result tables for all jobs for a specific schedule, click the radio button labeled Drop all result tables with schedule ID <scheduleID>, and click OK.
You can cancel all recurring queries that have the same schedule ID. Only queries that have not completed processing can be canceled.
To cancel all recurring queries for a specific schedule, click the radio push button labeled Cancel all queries with schedule ID <scheduleID>, and click OK.
To cancel all queries and drop all result tables for a Schedule ID, click the radio button labeled Cancel all queries and drop all result tables with schedule ID <scheduleID>, and click OK.