The job table of the rd_lsf database provides the primary key that links the rd_lsf and rd_workflow databases. The jobId value that is the primary key of this table is used to identify the runs in the runScripts table of the rd_workflow database. The columns in this table are:
- jobId - The job ID value
- jobName - The name of the job. This appears as the long name in the LSF batch system. It is of the form '<workflowName><runId><description>' where workflowName is the name of the workflow from the workflows table, runId the id from the run table, and description comes from the workflowScripts table. All three tables are in the rd_workflow database.
- user - The user that submitted the job
- status - The current status of the job (submitted, processing, finished, etc). This is updated by the various callback scripts used by the workflow system to maintain state.
- insertTime - The time job was first submitted to the LSF system.