Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Deletes all the log entries for the run of a single collection set. It also deletes the log entries from the SSIS tables for that run.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_syscollector_delete_execution_log_tree[ @log_id = ] log_id
, [ @from_collection_set = ] from_collection_set
Arguments
[ @log_id = ] log_id
Is the unique identifier for the collection set log. log_id is int.[ @from_collection_set = ] from_collection_set
Is the identifier for the collection set. from_collection_set is bit=1.
Return Code Values
0 (success) or 1 (failure)
Permissions
Requires membership in the dc_operator (with EXECUTE permission) fixed database role to execute this procedure.