Difference between revisions of "Housekeeping table"

Revision as of 04:06, 13 March 2007

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

The housekeeping table lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed.

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

    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

@@ Line 1: / Line 1: @@
+{{Wrongtitle|housekeeping table}}
 The '''housekeeping table''' lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed.
+== Table Description ==
+{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
+|- style="background: lightsteelblue"
+!  Field name !! Type         !! Null !! Key !! Default !! Extras
+|-
+|| tag        || varchar(64)  ||      || PRI ||         ||
+|-
+|| lastrun    || datetime     || YES  ||     || NULL    ||
+|-
+|}
+== Example Entries ==
+<pre>
+    tag: JobQueueCleanup
+lastrun: 2006-10-11 11:10:14
+</pre>
+<pre>
+    tag: InUseProgramsCleanup
+lastrun: 2006-10-11 11:05:14
+</pre>
+<pre>
+    tag: JobQueueRecover-localhost.localdomain
+lastrun: 2007-03-12 09:36:17
+</pre>
+<pre>
+    tag: MythFillDB
+lastrun: 2007-03-12 18:40:58
+</pre>
+<pre>
+    tag: DailyCleanup
+lastrun: 2007-03-12 09:36:17
+</pre>
 [[Category:DB Table]]