Understanding How to Cancel Currently Running Queries


Concept


Steps:

  1. Use the Query Administration - Executing page to display all currently running queries and to monitor queries that are running for specified periods.

    Step 1

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

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

    •  Enable

        Enables the selected query to be run, previewed, or scheduled.

    •  Disable

        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