syscollector_execution_log_full (Transact-SQL)

Provides information about a collection set or package when the execution log is full.

Column name	Data type	Description
log_id	bigint	Identifies each collection set execution. Used to join this view with other detailed logs. Is 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.
name	nvarchar(4000)	The name of the collection set or package that this log entry represents. Is nullable.
status	smallint	Indicates the current status of the collection set or package. Is nullable. Values are: 0 = running 1 = finished 2 = failed
runtime_execution_mode	smallint	Indicates whether the collection set activity was collecting data or uploading data. Is nullable.
start_time	datetime	The time that the collection set or package started. Is 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.
duration	int	The time, in seconds, that the package or collection set has been running. 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.
operator	nvarchar(128)	Identifies who started the collection set or package. Is nullable.
package_execution_id	uniqueidentifier	Provides a link to the SSIS log table. Is nullable.
collection_set_id	int	Provides a link to the data collection configuration table in msdb. Is nullable.

Permissions

Requires SELECT for dc_operator.

Zobacz także

Odwołanie

Data Collector Stored Procedures (Transact-SQL)

Data Collector Views (Transact-SQL)

Koncepcje

Data Collection

Historia zmian

Updated content
Corrected data type for log_id column.
Corrected data type for parent_log_id column, and updated the description to indicate that the value is not nullable.
Updated collection_mode column name to runtime_execution_mode.
Added failure_message column.
Removed failure_task column.