Difference between revisions of "Jobqueue table"
From MythTV Official Wiki
(→Fields) |
(→Fields) |
||
(One intermediate revision by the same user not shown) | |||
Line 41: | Line 41: | ||
*'''inserttime''' is the time the job was queued. | *'''inserttime''' is the time the job was queued. | ||
*'''type''' is the type of job. | *'''type''' is the type of job. | ||
− | **NONE = 0x0000 | + | ** NONE = 0x0000 |
+ | ** SYSTEMJOB = 0x00ff | ||
+ | *** TRANSCODE = 0x0001 | ||
+ | *** COMMFLAG = 0x0002 | ||
+ | *** METADATA = 0x0004 | ||
+ | *** PREVIEW = 0x0008 | ||
+ | ** USERJOB = 0xff00 | ||
+ | *** USERJOB1 = 0x0100 | ||
+ | *** USERJOB2 = 0x0200 | ||
+ | *** USERJOB3 = 0x0400 | ||
+ | *** USERJOB4 = 0x0800 | ||
*'''cmds''' | *'''cmds''' | ||
− | **RUN = 0x0000 | + | ** RUN = 0x0000 |
+ | ** PAUSE = 0x0001 | ||
+ | ** RESUME = 0x0002 | ||
+ | ** STOP = 0x0004 | ||
+ | ** RESTART = 0x0008 | ||
*'''flags''' | *'''flags''' | ||
− | **NO_FLAGS = 0x0000 | + | ** NO_FLAGS = 0x0000 |
+ | ** USE_CUTLIST = 0x0001 | ||
+ | ** LIVE_REC = 0x0002 | ||
+ | ** EXTERNAL = 0x0004 | ||
*'''status''' | *'''status''' | ||
− | **UNKNOWN = 0x0000 | + | ** 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 {{changeset|12917}}. | *'''schedruntime''' is the time that the job should run. Added in {{changeset|12917}}. |
Latest revision as of 08:09, 30 March 2020
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 | REFERENCES recorded(chanid,starttime) | |
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
- METADATA = 0x0004
- PREVIEW = 0x0008
- 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 [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.