Export (0) Print
Expand All

syscollector_execution_stats (Transact-SQL)


Updated: June 10, 2016

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 nameData typeDescription
log_idbigintIdentifies each collection set execution. Used to join this view with other detailed logs. Is not nullable.
task_namenvarchar(128)The name of the collection set or package task that this information is for. Is not nullable.
execution_row_count_inintNumber of rows processed at the beginning of data flow. Is nullable.
execution_row_count_outintNumber of rows processed at the end of data flow. Is nullable.
execution_row_count_errorsintNumber of rows that failed during the data flow. Is nullable.
execution_time_msintThe time, in milliseconds, required for the task to complete. Is nullable.
log_timedatetimeThe time that this information was logged. Is not nullable.

Requires SELECT permission for dc_operator.

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

Community Additions

© 2016 Microsoft