sys.sp_syscollector_delete_execution_log_tree

Description

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. The unique identifier for the collection set log. The identifier for the collection set.

Syntax

sp_syscollector_delete_execution_log_tree
[ @log_id = ] log_id
[ , [ @from_collection_set = ] from_collection_set ]
[ ; ]

Permissions

06/23/2025 It also deletes the log entries from the SSIS tables for that run. syntaxsql The unique identifier for the collection set log. @log_id is , with no default. The identifier for the collection set. @from_collection_set is , with a default of an empty string. (success) or (failure).