Automate Database Maintenance tool

Detailed descriptions and imagery explaining each tool available inside Habitat. Feel free to post feature requests under each tools forum post if you would like to see something added or changed in the tools.
Post Reply
User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Automate Database Maintenance tool

Post by 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
DatabaseMaintenance.PNG (48.73 KiB) Viewed 15803 times


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

DatabaseMaintenance1.PNG
DatabaseMaintenance1.PNG (63.55 KiB) Viewed 15803 times

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

DatabaseMaintenance2.PNG
DatabaseMaintenance2.PNG (16.05 KiB) Viewed 15803 times
DatabaseMaintenance3.PNG
DatabaseMaintenance3.PNG (17.45 KiB) Viewed 15803 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
Posts: 2
Joined: Sun Mar 13, 2022 4:02 pm
2

Re: Automate Database Maintenance tool

Post by 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?

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Automate Database Maintenance tool

Post by 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

User avatar
Cubert
Posts: 2430
Joined: Tue Dec 29, 2015 7:57 pm
8
Contact:

Re: Automate Database Maintenance tool

Post by 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.

Post Reply

Return to “Habitat Documentation Forum”