Table of Contents

Class DataCollectorSchema.ExecutionLog

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

syscollector_execution_log (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Provides information from the execution log for a collection set or package.


See dbo.syscollector_execution_log.

[Table(Database = "msdb", Schema = "dbo", Name = "syscollector_execution_log", IsView = true)]
public class DataCollectorSchema.ExecutionLog
Inheritance
DataCollectorSchema.ExecutionLog
Extension Methods

Properties

CollectionItemID

Identifies a collection item. Is nullable.

[Column("collection_item_id")]
[NotNull]
public int CollectionItemID { get; set; }

Property Value

int

CollectionSetID

Identifies the collection set or package that this log entry represents. Is not nullable.

[Column("collection_set_id")]
[NotNull]
public int CollectionSetID { get; set; }

Property Value

int

FailureMessage

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.

[Column("failure_message")]
[NotNull]
public string FailureMessage { get; set; }

Property Value

string

FinishTime

The time the run completed for finished packages and collection sets. Is nullable.

[Column("finish_time")]
[NotNull]
public DateTime FinishTime { get; set; }

Property Value

DateTime

LastIterationTime

For continuously running packages, the last time that the package captured a snapshot. Is nullable.

[Column("last_iteration_time")]
[NotNull]
public DateTime LastIterationTime { get; set; }

Property Value

DateTime

LogID

Identifies each collection set execution. Used to join this view with other detailed logs. Is not nullable.

[Column("log_id")]
[NotNull]
public long LogID { get; set; }

Property Value

long

Operator

Identifies who started the collection set or package. Is not nullable.

[Column("operator")]
[NotNull]
public string Operator { get; set; }

Property Value

string

PackageExecutionID

Provides a link to the SSIS log table. Is nullable.

[Column("package_execution_id")]
[NotNull]
public Guid PackageExecutionID { get; set; }

Property Value

Guid

PackageID

Identifies the collection set or package that generated this log. Is nullable.

[Column("package_id")]
[NotNull]
public Guid PackageID { get; set; }

Property Value

Guid

PackageName

The name of the package that generated this log. Is nullable.

[Column("package_name")]
[NotNull]
public string PackageName { get; set; }

Property Value

string

ParentLogID

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.

[Column("parent_log_id")]
[NotNull]
public long ParentLogID { get; set; }

Property Value

long

RuntimeExecutionMode

Indicates whether the collection set activity was collecting data or uploading data. Is nullable.

Values are:

0 = Collection

1 = Upload

[Column("runtime_execution_mode")]
[NotNull]
public short RuntimeExecutionMode { get; set; }

Property Value

short

StartTime

The time that the collection set or package started. Is not nullable.

[Column("start_time")]
[NotNull]
public DateTime StartTime { get; set; }

Property Value

DateTime

Status

Indicates the current status of the collection set or package. Is not nullable.

Values are:

0 = running

1 = finished

2 = failed

[Column("status")]
[NotNull]
public short Status { get; set; }

Property Value

short