Enable Database Scheduling¶
If the following message is shown upon login or when typing health login, the steps below should be carried out:
TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED
For general information on scheduling, see: Scheduling.
For considerations and guidance on frequency of the schedule to set up for your system. see the System Maintenance section of the Best Practices Guide.
Important
Schedules must be set up on all unified nodes. This ensures that they still run in the event of a failover and DR scenario.
For transaction database maintenance:
With for example a schedule name
dbtxn
:schedule add dbtxn voss transaction archive 7
or
schedule add dbtxn voss transaction delete 7
Note that transaction archiving also deletes transactions. For further details, see Database Commands for Transaction Management
Typing health login at the command line will now not show the
TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED
message.The schedule instance can be modified, for example weekly on Sunday:
schedule time dbtxn weekly 0