Viewing Flow Status and History
You can view a history of job, process flow, and service execution in Management Console and Enterprise Designer.
In Management Console
By default, transaction history is disabled because enabling transaction history can have an adverse impact on performance. If you want to see transaction history you must turn on transaction history logging by clicking the Transaction logging switch. To view user activity, consider using the audit log which you can access under .
The flow history list updates automatically every 30 seconds. If you want to update
it sooner, click the Refresh button .
In Enterprise Designer
To view flow status and history in Enterprise Designer, go to
.The flow history list updates automatically every 30 seconds. If you experience slowness when viewing execution history uncheck the Auto refresh box.
The Jobs tab is used to monitor job status and to pause, resume, or cancel jobs that are running as well as delete completed jobs.
- The Succeeded column shows the total number of records written as output by all the dataflow's sinks that have an empty value in the Status field.
- The Failed column shows the total number of records written as output by the dataflow's sinks that have a value of F in the Status field.
- The Malformed column shows the total number of records coming out of all source stage error ports.
The Process Flows tab is used to monitor process flow status and to cancel process flows that are running as well as delete completed process flows. If you click the plus sign next to any given process flow, you will view Activity Status information for the process flow. The following information is included in this area:
- ActivityName
- Includes the names of all activities, including any success activities, that make up the process flow.
- State
- The status of the activity (failed, succeeded, running, canceled).
- ReturnCode
- A code that indicates the result of the process flow. One of the following:
- 1
- The process flow failed.
- 0
- The process flow finished successfully.
- -1
- The process flow was canceled.
- Other numbers
- If the process flow contains a Run Program activity, the external program may return codes of its own. Any values in the ReturnCode column other than 1, 0, and -1 are from the external program. See the external program's documentation for an explanation of its return codes.
- Started
- The date and time the activity started.
- Finished
- The date and time the activity ended.
- Comment
- Any comments associated with the activity.