syscollector_execution_stats (Transact-SQL)
Provides information about task execution for a collection set or package.
Column name |
Data type |
Description |
---|---|---|
log_id |
bigint |
Identifies each collection set execution. Used to join this view with other detailed logs. Is not nullable. |
task_name |
nvarchar(128) |
The name of the collection set or package task that this information is for. Is not nullable. |
execution_row_count_in |
int |
Number of rows processed at the beginning of data flow. Is nullable. |
execution_row_count_out |
int |
Number of rows processed at the end of data flow. Is nullable. |
execution_row_count_errors |
int |
Number of rows that failed during the data flow. Is nullable. |
execution_time_ms |
int |
The time, in milliseconds, required for the task to complete. Is nullable. |
log_time |
datetime |
The time that this information was logged. Is not nullable. |
Permissions
Requires SELECT permission for dc_operator.
See Also