Viewing the detailed status of an ETL run
This topic explains how to view the detailed status of an ETL run by using the BMC Decision Support for Server Automation Console.
To view the detailed status of an ETL run by using the console
- Launch the BMC Decision Support for Server Automation Console, as described in Accessing-the-console.
- Click ETL Management > ETL Status.
On the ETL Status Summary page, in the ETL Run Name column, click the ETL run for which you want to view the detailed status.
The ETL Detailed Status page displays the following columns:Column
Description
Session Name
Represents a scenario
To see the details of a session, click the session name. For more details, see To browse sessions.Status
Indicates the status of a scenario run, as follows:
indicates that the scenario run completed successfully. 
indicates that the scenario run failed.
To view the step at which ETL failed and the reason for the failure, click . The Task Details page shows the error description and the destination command, which generated the error.
indicates that a scenario is running.
indicates that a scenario is waiting.
Start Time
Indicates the time when a scenario started to run
End Time
Indicates the time when a scenario run finished
Duration (s)
Indicates the time for a scenario run to finish
Comparison with last ETL run
Compares the time for a scenario run to finish in the current ETL run with the time for a scenario run in the last ETL run for a BMC Server Automation site
To view the time taken by a scenario run to finish in the last ETL runs, click the
icon. On the ETL Session History page, view the time taken by the scenario run in last 50 ETL runs.You can use the Search field on this page to search for sessions.
To browse sessions
On the ETL Detailed Status page, in the Session Name column, click a session for which you want to view the steps.
The Session Steps page displays the following columns:Column
Description
Step Name
Name of a step in the session
Status
Indicates whether a step has run successfully, as follows:
- indicates that the step run finished successfully.
indicates that the step run failed.- indicates that a step is running.
- indicates that a step is waiting.
Start Time
Time at which a step started to run
End Time
Time at which a step finished
Duration (s)
Time for a step to finish
Ins
Number of rows inserted in a reports data warehouse table because of the execution of the step
Upd
Number of rows updated in a reports data warehouse table because of the execution of the step
Del
Number of rows deleted from a reports data warehouse table because of the execution of the step
Step Type
Type of step, as defined in Oracle Data Integrator (ODI)
To view the tasks in a step, click the step in the Step Name column.
The Session Tasks page displays the following columns:Column
Description
Task Name
Name of a task in the step
Status
Indicates whether a task has run successfully, as follows:
- indicates that the task finished successfully.
- indicates that the task failed.
- indicates that a task is running.
- indicates that a task is waiting.
Object
Name of the object that got updated during the execution of the task
Name
Name of the operation that was performed on the object during the execution of the task
Start Time
Time at which a task started to run
End Time
Time at which a task finished
Duration (s)
Time for a task to finish
Ins
Number of rows inserted in a reports data warehouse table because of the execution of the task
Upd
Number of rows updated in a reports data warehouse table because of the execution of the task
Del
Number of rows deleted from a reports data warehouse table because of the execution of the task
- To view the task details, click the task in the Task Name column.
The Task Details page shows the task details.