App Control: How to reschedule task pruning in Database

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How to re-schedule task pruning on  database

Environment

• App Control Server: All versions
• Microsoft SQL server

Resolution

Run this query against the  database to reschedule the daily prune task:

update dbo.scheduled_tasks set schedule = '0 hh * * *' where task = 'DailyPruneTask

Example: 

This query will push back the Daily Prune Task by 2 hours
update dbo.scheduled_tasks set schedule = '0 22 * * *' where task = 'DailyPruneTask

 

Additional Information

• The daily task runs at midnight by default
• The schedule follows standard cron format