Reference > Database > WebSphere Commerce database tables > S

WebSphere Commerce database table: SCHBRDCST

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

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... 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... 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
SQL100520030427000	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

• Job scheduler data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search