Terminating and suspending

There are a number of ways to end or suspend a debug session. Various methods are described in this topic.

Terminate

Terminating immediately ends a debug session, and the stored procedure that you are debugging runs to completion.

To terminate a debug session:

  1. In the Debug view, select the debug project, target, or thread that you want to terminate.
  2. Perform one of the following tasks:
    • Select Run > Terminate.
    • Right-click and select Terminate from the pop-up menu. Alternatively, you can select Terminate and Remove to terminate the session and remove it from the Debug view.
Note: If you right-click the debug target, choosing Disconnect from the pop-up menu will also result in termination of the debug session. The stored procedure you are debugging will not terminate.

To terminate all debug sessions, right-click in the Debug view and choose Terminate All from the pop-up menu.

If you have terminated one or more sessions and want to remove them from the Debug view, right-click in the Debug view and choose Remove All Terminated from the pop-up menu.

Resume (Run)

If you are debugging a stored procedure which contains no active breakpoints, choosing to Resume suspended threads will result in an end of the debug session (that is, the stored procedure will run to completion and the debug session will terminate).

Note: When setting preferences, you can specify the number of seconds of inactivity before the SQL stored procedure that you are debugging runs to completion. If there is no debug activity for this length of time, the procedure and debug session will terminate. This option does not apply when debugging Java™ stored procedures.

Suspend

You can suspend execution of a thread in the stored procedure that you are debugging. When you choose to suspend execution of a thread, all threads in the stored procedure will suspend until you issue a Resume action.


Feedback