Bookshelf: About the DAC Current Run Tab

This tab displays a list of queued, running, and failed current ETL processes in the top pane. This list includes comprehensive information about each process.

NOTE: Once an ETL process completes, it is accessible from the Run History tab.

Table 29. Current Run Tab Columns
Column	Description
Name	Name of the ETL process
Execution Plan Name	The execution plan whose run-time instance is this record. This field is read only.
Process ID	ID for the process. This value is an integer that is incremented by 1 for every run. This value is stored as ETL_PROC_WID in all the Data Warehouse tables. This field is read only.
Run Status	Status of the run. The possible values are the following: Queued. A request has been submitted. Displayed in yellow in the Current Run list. Running. The server has picked up the run and starts processing it. Displayed in blue. Failed. One or more tasks has failed. Displayed in red. Completed. All tasks have completed without errors. Displayed in green.
Total Number of Tasks	Total number of tasks for this run. This field is read only.
Number of Failed Tasks	Sum total of tasks that have failed and that have stopped. This field is read only.
Number of Successful Tasks	Number of tasks whose status is completed. This field is read only.
Number of Tasks Still in Queue	Number of tasks whose prerequisite tasks have not completed, and the number of tasks whose prerequisite tasks are completed and are waiting for resources. This field is read only.
Start Timestamp	Start time of the ETL. Reflects the start time of every ETL attempt. For example, if the ETL fails and is run again, it gets a new start timestamp. The history of attempted runs is maintained in the audit trail for the run. This field is read only.
End Timestamp	End time of the ETL. Reflects the end time of every ETL attempt. For example, if the ETL fails and is run again, it gets a new end timestamp when the ETL is complete. The history of attempted runs is maintained in the audit trail for the run. This field is read only.
Duration	A calculated field that shows the difference between start and end time stamps.
Status Description	Displays messages generated during run time. You can add notes to this field for Completed runs.

Table 30. Current Run Subtabs
Tab	Description
Edit	Displays the status of the ETL selected in the top pane.
Description	Provides a description of the ETL process, including status and environment information. This description is updated at the beginning of the ETL process and when the process is complete.
Tasks	Displays run-time instances of the tasks. As the execution proceeds, the tasks are executed based on the dependency rules and some prioritization. As tasks complete, the tasks that depend on the completed tasks are notified and once their dependencies are completed, they become eligible to run. If a task fails, the administrator can address the failure and then requeue the task or mark it as completed. The DAC server polls for any changes in the failed task's detail status. If a failed task detail is queued, the task itself gets back into the ready to run queue and all its dependent tasks get into the queued status. The rules of prioritization are as follows: Tasks with no dependencies are executed first. If a task has failed and has been requeued, it gets the maximum priority. Tasks with greater phase priorities are executed next. When several tasks of the same phase are eligible to run, the tasks with greater task priorities are executed next.
Summary (Read Only)	Provides a summary (based on dynamic SQL) of the ETL selected in the top pane. A start and end time for each phase is included.
Task Details	Provides a execution details about each task associated with the ETL selected in the top pane.
Audit Trail (Read Only)	Provides the history of the ETL selected in the top pane.

Actions Available

The following actions are available in the top pane toolbar and in the right-click menu when the Current Run tab is active.

Start

This command restarts the selected ETL, after the ETL has failed, stopped, or been aborted.

Abort

This command causes an ETL in progress to abort. All currently running tasks will be aborted. The status of queued tasks and the ETL itself will change to Stopped.

Auto Refresh

This command allows you to turn on and off the automatic screen refresh functionality and set the refresh interval.

Get Log File

This command fetches the log file for this run from the DAC server and saves it in the ServerLog folder.

Mark as Completed

This command changes the status of a stopped or failed ETL to Completed. In the audit trail for this ETL, the status is Marked as Completed. Use this command with caution; it can cause the data warehouse to be inconsistent.

Analyze Run

This command saves a description of the run as an HTML file in the Log/Statistics folder.