Starts an upload of collection set data if the collection set is enabled.
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).
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.
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' ;