| title | syscollector_execution_log_full (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 6c8db22d-2e4c-4b7c-ac5a-8762ef1b175b | ||
| caps.latest.revision | 18 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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 [!INCLUDEssIS] log table. Is nullable. |
| collection_set_id | int | Provides a link to the data collection configuration table in msdb. Is nullable. |
Requires SELECT for dc_operator.
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection