Manually Run the DailyPruneTask Stored Procedure

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

 How to manually run the DailyPruneTask stored procedure.

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

1. Run SQL Server Management Studio as the Carbon Black Service Account
2. Execute the following script to verify the task_id of the DailyPruneTask:

   use das;
   select * from dbo.scheduled_tasks where task = 'DailyPruneTask'

3. Execute the following script, by first adjusting the task_id found in the previous step

   use das;
   EXEC dbo.DailyPruneTask @task_id = 'Step3_task_id'

Additional Information

• This task will require the Service Account correctly have permissions in the SQL Database.
• This task should not need to be executed manually, as it is scheduled to execute automatically.
  
  • If you are in a situation where manual execution of this task seems required, please open a case with Support to discuss further.
  • This task could take several hours to complete, and should only be executed during an appropriate maintenance window or as otherwise directed by Support.
• Execution of this task manually will not complete all daily maintenance that the Server completes (ex: DailyAntibodyPruningTask and DailyNamePruningTask).