WebSphere Commerce database table: SCHCMD

The URLsthat can be used as a scheduled job by a store. This is for the Scheduler menu in the Administration Console.

Column Descriptions

Column Name	Column Type	Description
SCHCMD_ID	BIGINT NOT NULL	A unique identifier of the defined store scheduler command.
STOREENT_ID	INTEGER	The store ID of the URL. Default value should be 0 which represents the site.
PATHINFO	VARCHAR(254)	The URL.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235248440	SCHCMD_ID	Primary Key
I0000758	STOREENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_736	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_235	SCHCMD_ID	CHKARRANG	SCHCMD_ID	Cascade

Related reference

• Job scheduler data model