DatabaseMaintenance - System Parameter
Keep your Nodinite Log Databases compact, healthy, and high-performing.
Nodinite is designed to perform scheduled maintenance jobs automatically, ensuring your integration platform remains efficient and reliable. However, a SQL DBA may choose to use alternative mechanisms for these tasks if preferred.
Use the System Parameter DatabaseMaintenance to control whether the Nodinite Logging Service performs these database maintenance jobs.
Maintenance jobs are scheduled to run between 03:00 AM and 04:00 AM, with the actual start time depending on other system activities. Cleanup operations have lower priority and execute after higher-priority tasks are completed.
Automate and optimize your Nodinite Log Database maintenance with the DatabaseMaintenance system parameter. This feature keeps your platform running smoothly and reliably, with minimal manual intervention. Expect to:
✅ Keep Log Databases compact and high-performing
✅ Automate reindex and shrink operations for optimal efficiency
✅ Ensure reliability and business continuity
✅ Minimize manual maintenance and downtime
Nodinite automatically schedules and runs essential maintenance jobs, so your integration platform stays efficient and healthy. SQL DBAs can still use their own preferred methods if needed.
Use the System Parameter DatabaseMaintenance to control whether the Nodinite Logging Service performs these jobs. Maintenance is scheduled between 03:00 AM and 04:00 AM, with cleanup operations running after higher-priority tasks.
Active database
- Reindex – Performed if the reported fragmentation count exceeds 10%.
Archive databases
- Reindex – Performed if the reported fragmentation count exceeds 10%.
- Shrink – Attempts to shrink the database to return allocated disk space to the system. Regular backups are a prerequisite.
The shrink operation is a privileged task requiring the account running the Logging Service to have the sysadmin role.
Configuration example
| Field | Data Type | Description |
|---|---|---|
| Enabled | Boolean (true/false) |
When true, Nodinite performs database maintenance jobs. When false, it does not. |
Automate and optimize your Nodinite Log Database maintenance with the DatabaseMaintenance system parameter. This feature keeps your platform running smoothly and reliably, with minimal manual intervention. Expect to:
✅ Keep Log Databases compact and high-performing
✅ Automate reindex and shrink operations for optimal efficiency
✅ Ensure reliability and business continuity
✅ Minimize manual maintenance and downtime
Nodinite automatically schedules and runs essential maintenance jobs, so your integration platform stays efficient and healthy. SQL DBAs can still use their own preferred methods if needed.
Use the System Parameter DatabaseMaintenance to control whether the Nodinite Logging Service performs these jobs. Maintenance is scheduled between 03:00 AM and 04:00 AM, with cleanup operations running after higher-priority tasks.
Frequently Asked Questions
Find more solutions and answers in the Nodinite System Parameters FAQ and the Troubleshooting user guide.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
Do I need to restart anything?
If this system parameter is set to true, the Logging Service performs the maintenance jobs. If you change this value, you do NOT need to restart anything. Changes are effective almost immediately, ensuring minimal disruption and maximum agility.