Table of Contents

Class DataCollectorSchema.ExecutionLogFull

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

syscollector_execution_log_full (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Provides information about a collection set or package when the execution log is full.


See dbo.syscollector_execution_log_full.

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

Properties

CollectionSetID

Provides a link to the data collection configuration table in msdb. Is nullable.

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

Property Value

int

Duration

The time, in seconds, that the package or collection set has been running. Is nullable.

[Column("duration")]
[NotNull]
public int Duration { 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 nullable.

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

Property Value

long

Name

The name of the collection set or package that this log entry represents. Is nullable.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Operator

Identifies who started the collection set or package. Is 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

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.

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

Property Value

short

StartTime

The time that the collection set or package started. Is 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 nullable.

Values are:

0 = running

1 = finished

2 = failed

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

Property Value

short