Export (0) Print
Expand All

syscollector_collection_sets (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

collection_set_id

int

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

collection_set_uid

uniqueidentifier

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

name

nvarchar(4000)

The name of the collection set. Is nullable.

target

nvarchar(max)

Identifies the target for the collection set. Is nullable.

is_system

bit

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.

is_running

bit

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

collection_mode

smallint

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.

proxy_id

int

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

schedule_uid

uniqueidentifier

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

collection_job_id

uniqueidentifier

Identifies the collection job. Is nullable.

upload_job_id

uniqueidentifier

Identifies the collection upload job. Is nullable.

logging_level

smallint

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

days_until_expiration

smallint

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

description

nvarchar(4000)

Describes the collection set. Is nullable.

dump_on_any_error

bit

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

dump_on_codes

nvarchar(max)

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

Requires SELECT for dc_operator, dc_proxy.

The data collector API only allows you to change or delete the collection sets that you create. The collection sets that are provided with the system cannot be modified or deleted. However, you can still enable or disable a system collection set, and change its configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft