Jobqueue table

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.