Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Requires SELECT permission for dc_operator.

Updated content

Corrected the data type for the log_id column, and updated the description to indicate that the value is not nullable.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.