Use the Query Administration - Executing page to display all currently running queries and to monitor queries that are running for specified periods.Step 1
For instance, if the Query Administration - Executing page indicates that a simple query takes more than 10 minutes to complete, you conclude that there is a problem with the query or the application server and start to investigate.Step 2
If a query is running, you can perform an action by clicking one of the following buttons:
• Kill Selected Processes
Forces the selected query to stop running.
• Logging On
Enables logging for the selected query.
• Logging Off
Disables logging for the selected query.
Enables the selected query to be run, previewed, or scheduled.
Disables the selected query from being run, previewed, or scheduled.Step 3
You have successfully reviewed the Understanding How to Cancel Currently Running Queries topic.
Table of Contents Start Topic