syscollector_execution_stats (Transact-SQL)
Applies to: 
SQL Server
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for