Difference between revisions of "Jobqueue table"
From MythTV Official Wiki
Blackcamera (talk | contribs) (→Fields) |
(Added schedruntime) |
||
| Line 30: | Line 30: | ||
|- | |- | ||
|| comment || varchar(128) || || || || | || comment || varchar(128) || || || || | ||
| + | |- | ||
| + | || schedruntime || datetime || || || 2007-01-01 00:00:00 || | ||
|- | |- | ||
|} | |} | ||
| Line 47: | Line 49: | ||
**UNKNOWN = 0x0000, QUEUED = 0x0001, PENDING = 0x0002, STARTING = 0x0003, RUNNING = 0x0004, STOPPING = 0x0005, PAUSED = 0x0006, RETRY = 0x0007, ERRORING = 0x0008, ABORTING = 0x0009, DONE = 0x0100, FINISHED = 0x0110, ABORTED = 0x0120, ERRORED = 0x0130, CANCELLED = 0x0140, | **UNKNOWN = 0x0000, QUEUED = 0x0001, PENDING = 0x0002, STARTING = 0x0003, RUNNING = 0x0004, STOPPING = 0x0005, PAUSED = 0x0006, RETRY = 0x0007, ERRORING = 0x0008, ABORTING = 0x0009, DONE = 0x0100, FINISHED = 0x0110, ABORTED = 0x0120, ERRORED = 0x0130, CANCELLED = 0x0140, | ||
*'''statustime''' is the time the status was last updated | *'''statustime''' is the time the status was last updated | ||
| + | *'''schedruntime''' is the time that the job should run. Added in [http://svn.mythtv.org/trac/changeset/12917 changeset 12917]. | ||
== Example Entries == | == Example Entries == | ||
Revision as of 02:34, 13 December 2007
Note: The correct title of this article is jobqueue table. It appears incorrectly here due to technical restrictions.
The jobqueue table maintains a list of outstanding, in-progress and recently finished commercial flagging, transcoding and user processing jobs.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| id | int(11) | PRI | NULL | auto_increment | |
| chanid | int(10) | MUL | 0 | ||
| starttime | datetime | 0000-00-00 00:00:00 | |||
| inserttime | datetime | 0000-00-00 00:00:00 | |||
| type | int(11) | 0 | |||
| cmds | int(11) | 0 | |||
| flags | int(11) | 0 | |||
| status | int(11) | 0 | |||
| statustime | timestamp | CURRENT_TIMESTAMP | |||
| hostname | varchar(255) | ||||
| args | blob | ||||
| comment | varchar(128) | ||||
| schedruntime | datetime | 2007-01-01 00:00:00 |
Fields
- id is a unique identifier for entries in the table.
- chanid relates to the chanid field of the channel table.
- starttime is the start time of the recording.
- inserttime is the time the job was queued.
- type is the type of job.
- NONE = 0x0000, SYSTEMJOB = 0x00ff, TRANSCODE = 0x0001, COMMFLAG = 0x0002, USERJOB = 0xff00, USERJOB1 = 0x0100, USERJOB2 = 0x0200, USERJOB3 = 0x0400, USERJOB4 = 0x0800
- cmds
- RUN = 0x0000, PAUSE = 0x0001, RESUME = 0x0002, STOP = 0x0004, RESTART = 0x0008
- flags
- NO_FLAGS = 0x0000, USE_CUTLIST = 0x0001, LIVE_REC = 0x0002, EXTERNAL = 0x0004
- status
- UNKNOWN = 0x0000, QUEUED = 0x0001, PENDING = 0x0002, STARTING = 0x0003, RUNNING = 0x0004, STOPPING = 0x0005, PAUSED = 0x0006, RETRY = 0x0007, ERRORING = 0x0008, ABORTING = 0x0009, DONE = 0x0100, FINISHED = 0x0110, ABORTED = 0x0120, ERRORED = 0x0130, CANCELLED = 0x0140,
- statustime is the time the status was last updated
- schedruntime is the time that the job should run. Added in changeset 12917.
Example Entries
id: 4061
chanid: 1039
starttime: 2007-01-13 09:00:00
inserttime: 2007-03-12 16:33:25
type: 1
cmds: 0
flags: 1
status: 272
statustime: 2006-12-10 22:18:48
hostname: localhost.localdomain
args:
comment: High Quality: 4.5 GB => 4.5
id: 4588
chanid: 1005
starttime: 2007-03-10 20:00:00
inserttime: 2007-03-11 15:56:13
type: 1
cmds: 0
flags: 1
status: 272
statustime: 2007-03-11 17:35:46
hostname: localhost.localdomain
args: RENAME_TO_NUV
comment: Low Quality: 1.5 GB => 799.9
id: 4559
chanid: 1039
starttime: 2007-03-10 08:00:00
inserttime: 2007-03-10 10:30:00
type: 2
cmds: 0
flags: 0
status: 272
statustime: 2007-03-10 12:41:26
hostname: localhost.localdomain
args:
comment: Finished, 11 break(s) found.
