syscollector_collection_sets (Transact-SQL)
Provides information about a collection set, including schedule, collection mode, and its state.
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. For more information about how to obtain a dump file, see the How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 article in the Microsoft Knowledge Base. |
Permissions
Requires SELECT for dc_operator, dc_proxy.
Remarks
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.
See Also
Reference
Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Concepts
Change History
Updated content |
|---|
Corrected the data type for the name column, and corrected the description to indicate that the value is nullable. |
Corrected the description for the collection_job_id column to indicate that the value is nullable. |
Corrected the description for the upload_job_id column to indicate that the value is nullable. |
Added the logging_level column. |
Added the dump_on_any_error column. |
Added the dump_on_codes column. |