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

Reference

Data Collector Stored Procedures (Transact-SQL)

Data Collector Views (Transact-SQL)

Concepts

Data Collection

Change History

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