Export (0) Print
Expand All

syscollector_execution_stats (Transact-SQL)

Provides information about task execution for a collection set or package.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft