TheSchwartz Job Table

Purpose

This table stores the actual operations needed to be done by TheSchwartz for executing periodic tasks.

Fields

• ts_job_jobid - int(11) - The table's primary key.
• ts_job_ts_job_arg - mediumblob - A binary storage area containing a serialized form of the arguments sent to the task.
• ts_job_coalesce - varchar(255).
• ts_job_funcid - int(11) - A foreign key pointing to ts_funcmap.
• ts_job_grabbed_until - int(11) - The timestamp for when the task will be released. The default value is 0.
• ts_job_insert_time - int(11) - The UNIX timestamp for when the task was created.
• ts_job_priority - int(11) - The task's priority. Lower numbers are higher priority.
• ts_job_run_after - int(11) - The UNIX timestamp identifying when the task can be run. The default is the same time as insert_time.
• ts_job_uniqkey - varchar(255) - A unique identifier used by TheSchwartz.

Indexes

• mt_ts_job_funccoal - columns:
  • ts_job_funcid
  • ts_job_coalesce
• mt_ts_job_funcrun - columns:
  • ts_job_funcid
  • ts_job_run_after
• mt_ts_job_funcpri - columns:
  • ts_job_funcid
  • ts_job_priority
• mt_ts_job_uniqfunc - columns:
  • ts_job_funcid
  • ts_job_uniqkey