Table of Contents

Class DataCollectorSchema.CollectionSet

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

syscollector_collection_sets (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Provides information about a collection set, including schedule, collection mode, and its state.


See dbo.syscollector_collection_sets.

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

Properties

CollectionJobID

Identifies the collection job. Is nullable.

[Column("collection_job_id")]
[NotNull]
public Guid CollectionJobID { get; set; }

Property Value

Guid

CollectionMode

Specifies the collection mode for the collection set. Is not nullable.

Collection mode is one of the following:

0 - Cached mode. Data collection and upload are on separate schedules.

1 - Non-cached mode. Data collection and upload are on the same schedule.

[Column("collection_mode")]
[NotNull]
public short CollectionMode { get; set; }

Property Value

short

CollectionSetID

The local identifier for the collection set. Is not nullable.

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

Property Value

int

CollectionSetUID

The globally unique identifier for the collection set. Is not nullable.

[Column("collection_set_uid")]
[NotNull]
public Guid CollectionSetUID { get; set; }

Property Value

Guid

DaysUntilExpiration

The number of days that the collected data is saved in the management data warehouse. Is not nullable.

[Column("days_until_expiration")]
[NotNull]
public short DaysUntilExpiration { get; set; }

Property Value

short

Description

Describes the collection set. Is nullable.

[Column("description")]
[NotNull]
public string Description { get; set; }

Property Value

string

DumpOnAnyError

Turned on (1) or off (0) to indicate whether to create an SSIS dump file on any error. Is not nullable.

[Column("dump_on_any_error")]
[NotNull]
public bool DumpOnAnyError { get; set; }

Property Value

bool

DumpOnCodes

Contains the list of SSIS error codes that are used to trigger the dump file. Is nullable.

[Column("dump_on_codes")]
[NotNull]
public string DumpOnCodes { get; set; }

Property Value

string

IsRunning

Indicates whether or not the collection set is running. Is not nullable.

[Column("is_running")]
[NotNull]
public bool IsRunning { get; set; }

Property Value

bool

IsSystem

Turned on (1) or off (0) to indicate if the collection set was included with the data collector or if it was added later by the dc_admin. This could be a custom collection set developed in-house or by a third party. Is not nullable.

[Column("is_system")]
[NotNull]
public bool IsSystem { get; set; }

Property Value

bool

LoggingLevel

Specifies the logging level (0, 1 or 2). Is not nullable.

[Column("logging_level")]
[NotNull]
public short LoggingLevel { get; set; }

Property Value

short

Name

The name of the collection set. Is nullable.

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

Property Value

string

ProxyID

Identifies the proxy that is used to run the collection set job step. Is nullable.

[Column("proxy_id")]
[NotNull]
public int ProxyID { get; set; }

Property Value

int

ScheduleUID

Provides a pointer to the collection set schedule. Is nullable.

[Column("schedule_uid")]
[NotNull]
public Guid ScheduleUID { get; set; }

Property Value

Guid

Target

Identifies the target for the collection set. Is nullable.

[Column("target")]
[NotNull]
public string Target { get; set; }

Property Value

string

UploadJobID

Identifies the collection upload job. Is nullable.

[Column("upload_job_id")]
[NotNull]
public Guid UploadJobID { get; set; }

Property Value

Guid