Environment
- App Control Server: All versions
- Microsoft SQL server
Objective
How to re-schedule task pruning on database
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 Notes
- The daily task runs at midnight by default
- The schedule follows standard cron format