syscollector-execution-stats-transact-sql.md

title	syscollector_execution_stats (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	syscollector_execution_stats syscollector_execution_stats_TSQL
dev_langs	TSQL
helpviewer_keywords	syscollector_execution_stats view data collector view
ms.assetid	23e35ac5-fbbf-4922-970c-f4fac44c1263
caps.latest.revision	17
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

syscollector_execution_stats (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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