| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
fn_syscollector_get_execution_details (Transact-SQL) |
fn_syscollector_get_execution_details (Transact-SQL) |
rwestMSFT |
randolphwest |
03/04/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Returns a portion of the [!INCLUDEssIS] log (sysssislog) matching the package_execution_id for the given package. The table contains one row for each logging entry that is generated at run time by packages or their tasks and containers.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
fn_syscollector_get_execution_details ( log_id )
log_id
The local unique identifier for the execution log. log_id is int.
| Column name | Data type | Description |
|---|---|---|
| id | int | The unique identifier of the logging entry. |
| event | sysname | The name of the event that generated the logging entry. |
| computer | nvarchar | The computer on which the package ran when the logging entry was generated. |
| operator | nvarchar | The user name of the person or agent that ran the package that generated the logging entry. |
| source | nvarchar | The name of the executable that generated the logging entry. |
| sourceid | uniqueidentifier | The GUID of the executable that generated the logging entry. |
| executionid | uniqueidentifier | The GUID of the execution instance of the executable that generated the logging entry. |
| starttime | datetime | The time that the package began to run. |
| endtime | datetime | The time that the package completed. |
| datacode | int | An integer value that identifies the event associated with the log entry. "0" indicates that the event provided no identifier. |
| databytes | image | A byte array that identifies a return value. |
| message | nvarchar | A description of the event and the information associated with the event. |
Requires SELECT permission for dc_operator.
Enable Package Logging in SQL Server Data Tools
Data Collection