syscollector_execution_log (Transact-SQL)

Applies to: SQL Server

Provides information from the execution log 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.
parent_log_id	bigint	Identifies the parent package or collection set. Is not nullable. The IDs are chained in the parent-child relationship, which enables you to determine which package was started by which collection set. This view groups the log entries by their parent-child linkage and indents the names of the packages, so that the call chain is clearly visible.
collection_set_id	int	Identifies the collection set or package that this log entry represents. Is not nullable.
collection_item_id	int	Identifies a collection item. Is nullable.
start_time	datetime	The time that the collection set or package started. Is not nullable.
last_iteration_time	datetime	For continuously running packages, the last time that the package captured a snapshot. Is nullable.
finish_time	datetime	The time the run completed for finished packages and collection sets. Is nullable.
runtime_execution_mode	smallint	Indicates whether the collection set activity was collecting data or uploading data. Is nullable. Values are: 0 = Collection 1 = Upload
status	smallint	Indicates the current status of the collection set or package. Is not nullable. Values are: 0 = running 1 = finished 2 = failed
operator	nvarchar(128)	Identifies who started the collection set or package. Is not nullable.
package_id	uniqueidentifier	Identifies the collection set or package that generated this log. Is nullable.
package_name	nvarchar(4000)	The name of the package that generated this log. Is nullable.
package_execution_id	uniqueidentifier	Provides a link to the SSIS log table. Is nullable.
failure_message	nvarchar(2048)	If the collection set or package failed, the most recent error message for that component. Is nullable. To obtain more detailed error information, use the fn_syscollector_get_execution_details (Transact-SQL) function.

Permissions

Requires SELECT for dc_operator.

See Also

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