Contents
Package Explorer

Package Execution State

There are two ways to see package execution process:

  • Execution Log.
  • Execution State Window.


Execution Log

Package Output window contains execution log -- a list of all events occurred during package execution.




Figure 147:  Example of package execution log.




Execution State Window

To open this window user should choose the corresponding main menu item.




Figure 148:  Opening package execution state window.




Execution state window contains a list of all databases and information about currently executing scripts. Such information includes script name (with a path inside the package) and current execution state. Some execution states are colored to draw user attention to.




Figure 149:  Example of package execution state window.




Execution states

Possible states are:
  • Waiting
  • Executing
  • ERROR!
  • Cancelled
  • Finished
  • COMPLETED!


Waiting

The script is waiting in a queue before the execution (for example, if the limit of server connections has been reached).

Executing

The script is currently executing.

ERROR!

There was an error during the corresponding script execution. Detailed error information can be found in the Execution Log or in 'Messages' items in the 'Package Result' window. Lines with 'ERROR!' state are marked red.

Cancelled

The script execution was cancelled by the user. Lines with this state are marked yellow.

Finished

The current script execution has been finished. Such state means that corresponding database waits for the next script to be executed (due to 'Sync' mode or server connection limits).

COMPLETED!

All scripts have been successfully executed on the corresponding database, no more scripts to execute left. Lines with this state are marked green.

Script cancellation

The upper left corner of state window column contains a Cancel button. The user can cancel package execution on any particular database by selecting check-boxes on appropriate rows and pressing the 'Cancel' button. In that case currently executing scripts on the selected databases are aborted, and all subsequent scripts on these databases are suspended too.

This operation cannot be undone!




Figure 150:  Script cancellation in the package execution state window.







© 2001-2017 JNetDirect, Inc. All Rights Reserved.