WebSphere Commerce database table: SCHBRDCST

This table is used to log the status of broadcast commands for each of the clones.

Column Descriptions
Column Name Column Type Description
JOBREFNUM BIGINT NOT NULL Job reference number.
JOBSTATE CHAR(2) NOT NULL State of this broadcast job. Valid values are as follows:

  • R=running

  • C=complete

  • CF=complete fail

PREFSTARTTIME TIMESTAMP NOT NULL Preferred start time for this broadcast job.
ACTLSTARTTIME TIMESTAMP Actual start time for the command for this clone.
ENDTIME TIMESTAMP Command end time.
RESULT CHAR(1) Job result. Valid values are as follows:

  • S=successful

  • F=failed

EXCEPTIONCODE VARCHAR(254) Command exception code.
CLONEID CHAR(32) NOT NULL Clone ID. This is the instance name defined for Request Servlet initialization.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235248280 JOBREFNUM+CLONEID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_735 JOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade
Related reference