Table information for 'tap_schema.tapjobs'

General

Table Description: A non-standard (and not tap-accessible) table used for managing asynchronous TAP jobs. It is manipulated through TAP job creation and destruction internally. Under very special circumstances, operators can use the gavo admin cleantap command to purge jobs from this table. Note that such jobs have corresponding directories in $STATEDIR/uwsjobs, which will be orphaned if this table is manipulated through SQL.

This table is not available for ADQL queries and through the TAP endpoint.

Resource Description: VESPA PA team server's Table Access Protocol (TAP) service with table metadata.

For a list of all services and tables belonging to this table's resource, see Information on resource '__system__/tap'

Citing this table

To cite the table as such, we suggest the following BibTeX entry:

@MISC{vo:tap_schema_tapjo,
  year=2009,
  title={Untitled Resource},
  author={Loic Trompet},
  url={http://vespa-ae.oma.be/tableinfo/tap_schema.tapjobs},
  howpublished={{VO} resource provided by the {VESPA} PA team server}
}

Columns

Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
jobId Jobid Internal id of the job. At the same time, uwsDir-relative name of the job directory. N/A N/A
phase Phase The state of the job. N/A N/A
executionDuration Executionduration Job time limit s N/A
destructionTime Destructiontime Time at which the job, including ancillary data, will be deleted N/A N/A
owner Owner Submitter of the job, if verified N/A N/A
parameters Parameters Pickled representation of the parameters (except uploads) N/A N/A
runId Runid User-chosen run Id N/A N/A
startTime Starttime UTC job execution started N/A N/A
endTime Endtime UTC job execution finished N/A N/A
error Error some suitable representation an error that has occurred while executing the job (null means no error information has been logged) N/A N/A
creationTime Creationtime UTC job was created N/A N/A
pid Pid A unix pid to kill to make the job stop N/A N/A

Columns that are parts of indices are marked like this.

Other

The following services may use the data contained in this table:

VOResource

VO nerds may sometimes need VOResource XML for this table.