syscollector_execution_log (Transact-SQL)
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
Reference
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Concepts
Change History
Updated content |
|---|
Corrected the data type for the log_id column. |
Corrected the data type for the parent_log_id column, and updated the description to indicate that the value is not nullable. |
Corrected the data type for the package_name column. |
Corrected the data type for the failure_message column. |