sp_syscollector_start_collection_set (Transact-SQL)
Applies to:
SQL Server
Starts a collection set if the collector is already enabled and the collection set isn't running. If the collector isn't enabled, enable the collector by running sp_syscollector_enable_collector and then use this stored procedure to start a collection set.
Transact-SQL syntax conventions
Syntax
sp_syscollector_start_collection_set
[ [ @collection_set_id = ] collection_set_id ]
[ , [ @name = ] N'name' ]
[ ; ]
Arguments
[ @collection_set_id = ] collection_set_id
The unique local identifier for the collection set. @collection_set_id is int, with a default of NULL
. @collection_set_id must have a value if @name is NULL
.
[ @name = ] N'name'
The name of the collection set. @name is sysname, with a default of NULL
. @name must have a value if @collection_set_id is NULL
.
Return code values
0
(success) or 1
(failure).
Remarks
sp_syscollector_create_collection_set
must be run in the context of the msdb
system database and SQL Server Agent must be enabled.
This procedure fails when run against a collection set that doesn't have a schedule. If the collection set doesn't have a schedule (because its collection mode is set to non-cached, for example), use the sp_syscollector_run_collection_set stored procedure to start the collection set.
This procedure enables the collection and upload jobs for the specified collection set, and immediately starts the collection agent job if the collection set has its collection mode set to cached (0
). For more information, see sp_syscollector_create_collection_set.
If the collection set doesn't contain any collection items, this operation has no effect. Error 14685 is returned as a warning.
Permissions
Requires membership in the dc_operator fixed database role to execute this procedure. If the collection set doesn't have a proxy account, membership in the sysadmin fixed server role is required.
Examples
The following example starts a collection set using its identifier.
USE msdb;
GO
EXEC sp_syscollector_start_collection_set @collection_set_id = 1;
Related content
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir