Automate Database Maintenance tool

[Cubert]

Habitat comes with a new plugin to assist you in database maintenance based on the Automate communities input.

You can enable different maintenance services that will complete daily a set of maintenance tasks. You can select to enable or disable any of the tasks and only run what you want on the database.

DatabaseMaintenance.PNG (48.73 KiB) Viewed 17612 times

There is also access to the function editor (beta) that allows you to modify the current functions or add new ones.

DatabaseMaintenance1.PNG (63.55 KiB) Viewed 17612 times

From this view you can select to manage the different function groups and functions

DatabaseMaintenance2.PNG (16.05 KiB) Viewed 17612 times

DatabaseMaintenance3.PNG (17.45 KiB) Viewed 17612 times

Currently Database Maintenance functions are integrated into Automate to execute once per day in or around 12 am.
Other function types are scheduled to be integrated into automate in the near future.

[twscottiii]

I have enabled the database maintenance task groups and made sure the functions are enabled within the groups but they don't appear to be running or doing anything?

Is there a way to trigger these manually? In particular I am trying to clean up a very large number of completed tickets.

Is there a log for these tasks?

[Cubert]

Yeap it is logged, Logs on the server at C:\Program Files\LabTech\Logs\plugin_Habitat.txt


DB Maintenance runs daily at 12 AM so look in logs for that time frame as seen below.

LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Flush Info Messages].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Reset Monitors].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Flush WindowUpdateETLFiles Table].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Stalled Agent Maintenance) scripted for [17] agents.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Stalled Agent Operations completed.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Powershell Operations starting.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Printer Status Operations starting.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Windows Updates Operations starting.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat AD Password Expire Operations starting.:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Computer Role Definitions].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Reset Monitors].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Flush WindowUpdateETLFiles Table].:::
LTAgent v220.57 - 3/13/2022 12:00:09 AM - Plugin Habitat, Version=1.0.1.21, Culture=neutral, PublicKeyToken=null: Habitat Operations (Database Maintenance Functions) Executing [Remove Closed

[Cubert]

If you want a running cleanup daily then use the DB maintenance. You can run a manual dump of that data using the Habitat SQL analyzer, and it is instant.