Export (0) Print
Expand All

sp_syscollector_upload_collection_set (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Starts an upload of collection set data if the collection set is enabled.

System_CAPS_importantImportant

This stored procedure can only be used for collection sets that are configured for cached mode data collection and upload.

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

Topic link icon Transact-SQL Syntax Conventions

 

sp_syscollector_upload_collection_set [[ @collection_set_id = ] collection_set_id ] , [[ @name = ] 'name' ] 

[ @collection_set_id = ] collection_set_id

Is the unique local identifier for the collection set. collection_set_id is int and must have a value if name is NULL.

[ @name = ] 'name'

Is the name of the collection set. name is sysname and must have a value if collection_set_id is NULL.

0 (success) or 1 (failure)

Either collection_set_id or name must have a value; both cannot be NULL.

This procedure can be used for starting an on-demand upload for a running collection set. It can only be used for collection sets that are configured for cached mode data collection and upload. This enables a user to obtain data to analyze without having to wait for a scheduled upload.

Requires membership in the dc_operator (with EXECUTE permission) fixed database role to execute this procedure.

Does an on-demand upload of a collection set named Simple Collection Set.

USE msdb;
GO
EXEC sp_syscollector_upload_collection_set @name = 'Simple Collection Set' ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft