Housekeeping table

Note: The correct title of this article is housekeeping table. It appears incorrectly here due to technical restrictions.

The housekeeping table lists housekeeping events and the time at which they were last performed and succeeded.

Some examples of the events recorded are database backups, cleanups, etc, as well as other events such as when the hardware profiler was run, logs cleaned, etc.

The hostname where the housekeeping took place is also recorded in some cases.

Table Description

Field name	Type	Null	Key	Default	Extras
tag	varchar(64)		PRI	NULL
hostname	varchar(64)	YES		NULL
lastrun	datetime	YES		NULL
lastsuccess	datetime	YES		NULL

Example Entries

    tag: JobQueueCleanup
lastrun: 2006-10-11 11:10:14

    tag: InUseProgramsCleanup
lastrun: 2006-10-11 11:05:14

    tag: JobQueueRecover-localhost.localdomain
lastrun: 2007-03-12 09:36:17

    tag: MythFillDB
lastrun: 2007-03-12 18:40:58

    tag: DailyCleanup
lastrun: 2007-03-12 09:36:17

        tag: ThemeUpdateNotifications
   hostname: NULL
    lastrun: 2019-01-24 06:27:15
lastsuccess: 2019-01-24 06:27:15

        tag: DBCleanup
   hostname: NULL
    lastrun: 2019-01-23 18:38:22
lastsuccess: 2019-01-23 18:38:22

        tag: HardwareProfiler
   hostname: <backend device>
    lastrun: 2019-01-03 00:07:52
lastsuccess: 2018-12-04 18:28:38