The runScripts table of the rd_workflow database provides the LSF output of the runs of the various programs/scripts as well as the jobId of the run that links the run to the data in the rd_lsf database.  The columns of this table are:

  • runId - The ID of the run from the run table of the rd_workflow database.  This value is used as the workflowId in the build table of the rd_releasemgr database to link the two databases.
  • scriptId - The ID of the program/script (from the workflowScripts table) that was run.  This value plus the value from the runId column, uniquely identify every entry in the table
  • jobId - the job ID from the job table of the rd_lsf database.  This value provides the linkage between the rd_workflow and rd_lsf databases
  • rank - Unused.  No idea what this one is.  It always seems to be zero.  It is probably supposed to be a mirror of the rank value from the job table in the rd_lsf database
  • output - The output for the job from the LSF batch queuing system.
  • submitTime - The time the run was submitted to the LSF system
  • startTime - The time the run actually started
  • stopTime - The time the run completed execution
  • No labels