The second database job is the DAMON data monitor job. The DAMON job runs the majority of the background processing and is responsible for running background clean up processes required by the application that can potentially take a relatively long time to run.
Microsoft SQL Server and DAMON
By default, DAMON runs every Saturday. You can set it to run every two weeks or on a specific day. To run DAMON every two weeks, use the following command to set the interval: -eg 2W
To set DAMON to run on a specific day, use the following setting under namespace: 'Database.background.Damon'
DayOfWeek
DAMON Procedures
DAMON cleans the:
- BGPLOG table containing the background logs.
- REFRDEL table.
- PRMQUEUE table.
- Remaining USESSION records.
- Logically deleted records.
- PAUDIT table.
- USESSION audit table (USESSAUD).
You can also dynamically extend DAMON functionality via the user-defined procedure, USER_DEFINED_BACKGROUND.