syscollector_execution_stats (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection