• Article

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.