Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
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.
See Also
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection