Page 1 of 1

Integrate the "Database Maintenance" in an daily restart.

Posted: 30 Jun 2021, 10:18
by Mexenheister
Hi,
is it possible to integrate the "Database Maintenance" from the "Tools and Scripts" page in the daily restart routine?

For example:
  1. Stop server
  2. Run "Database Maintenance" (with a specific set of settings)
  3. Start Server
All automated in a script with a cronjob (maybe?)

Greetings

Mexenheister

Re: Integrate the "Database Maintenance" in an daily restart.

Posted: 10 Jul 2021, 00:54
by Nyuton
no, not possible

and it would be useless cause running the cleanups so frequently doesn't give you any benefit.
using it once a month is enough to keep the DB at a reasonable size.

Re: Integrate the "Database Maintenance" in an daily restart.

Posted: 10 Jul 2021, 16:40
by mazytus
If you know SQL, then you can create additional procedures in the lif_n database and add the corresponding calls to patch.sql