| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
syscollector_execution_stats (Transact-SQL) |
syscollector_execution_stats (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE 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. |
Requires SELECT permission for dc_operator.
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection