Database Maintenance automation

[maxlieb901]

Hello,
I would like to automate the process described here:
https://community.lansweeper.com/t5/troubleshooting-your/clear-tables-to-free-up-space-and-improve-p...
has anyone done this?

[maxlieb901]

Hi David,
Understood.
Just wanted to clarify - are those completely standard SQL server operations, or do they differ somehow?
Does the database maintenance tool do anything different from what I can do from SQL Server Management Studio?

[David_GF]

hi @maxlieb901 The historcy clean up options are run daily (at Lansweeper service start, and then every 24 hours). You could automate the Truncate/Shrink/Compact and rebuild indexes part by running a corn job or a scheduled task on your SQL Server, or with a script to be run when executing the script, but that falls outside of Lansweeper support.