Manually Run App Control Scheduled Tasks / Stored Procedures

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

 How to manually run Scheduled Tasks for Carbon Black App Control such as:

• DailyAntibodyPruningTask
• DailyNamePruningTask
• DailyPruneTask

Environment

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

Resolution

WARNING: These steps should not be performed unless directed to by Broadcom Support. Some stored procedures can up to 6 hours to complete.

 

1. Confirm the Service Account has the correct permissions
2. Run SQL Server Management Studio as the Carbon Black Service Account
3. Open Services.msc
4. Stop the Carbon Black App Control Reporter and Carbon Black App Control Server services
5. Execute the following script to find the Task ID of the stored procedure
   

   select * from das.dbo.scheduled_tasks where task = 'StoredProcedureName'
   
   Example:
   select * from das.dbo.scheduled_tasks where task = 'DailyAntibodyPruningTask'

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

   EXEC das.dbo.DailyPruneTask @task_id = 'Step3_task_id'
   
   Example:
   EXEC das.dbo.DailyAntibodyPruningTask @task_id = '9'