WebSphere Commerce database table: SRCH

SRCH_SCHSTATUS

Reserved for IBM internal use. Log of the status of scheduled jobs

Column Descriptions:

Name Type Description
SCSACTLSTART VARCHAR(254)
SCSLASTUPDATE TIMESTAMP NOT NULL Default current timestamp.
SCSINSTREFNUM BIGINT NOT NULL Instance number for this run of job.
SCSJOBNBR BIGINT NOT NULL This number refers to a job defined in the SCHCONFIG table
SCSPREFSTART TIMESTAMP NOT NULL
SCSPROGRESS VARCHAR(254)
SCSPROGRESSMSG VARCHAR(1000)
SCSREASONCODE VARCHAR(64)
SCSSTATE CHAR (2) NOT NULL State of the scheduled job.

I - The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table
IF - The scheduled job is rescheduled to run. There was a previous failed attempt to execute the job.
R - The scheduled job is running. The job execution start time is recorded in either the SCSACTLSTART column of the SCHSTATUS table or SCHACTIVE table. The SCSQUEUE column indicates which JVM process is running the job.
RF - The scheduled job is running. There was a previous failed attempt to execute the job.
C - The scheduled job has completed successfully. The job execution finish time is recorded in the SCSEND column of either the SCHSTATUS table or the SCHACTIVE table.
CF - The same as state C except there was an exception while executing the scheduled job. The job failed to execute successfully.
W - There is a check task command assigned to the scheduled job. This means that before the job is executed, there is a side process that will execute to determine whether the job really needs to be run. This saves the overhead of running a scheduled job when it does not need to be run. (This parameter is mostly used for store level scheduled jobs)

SCSPREFSTART TIMESTAMP NOT NULL Preferred start time for this job
SCSACTLSTART TIMESTAMP Actual start time for this run of the job
SCSRESULT CHAR (1) Result of job: success or fail
SCSQUEUE VARCHAR (128) Indicates the job queue.
The queue name is of the format hostName:cloneId:applicationType,
where the hostName and applicationType components are defined in the SCHCONFIG table and cloneId is generated
SCSEND TIMESTAMP End time for this job
SCSATTLEFT INTEGER Number of retry attempts left
SCSSEQUENCE INTEGER Scheduling policy for this job
SCSINSTRECOV BIGINT If this is a retry of a failed job this column refers to the instance of the failed job
TENANT_ID BIGINT NOT NULL DEFAULT 0 The ID of the tenant in the multi-tenant environment
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
SCSPROGRESSMSG VARCHAR(1000) Reserved for IBM internal use only.
SCSPROGRESS VARCHAR(254) Reserved for IBM internal use only.
SCSREASONCODE VARCHAR(64) Reserved for IBM internal use only.
SCSACTLSTART TIMESTAMP Reserved for IBM internal use only.
SCSPREFSTART TIMESTAMP Not null.
SCSLASTUPDATE TIMESTAMP Not null. Default current timestamp.

Indexes:

Name Column Names Type
P_0049 SCSINSTREFNUM Primary Key
I0001543 SCSPREFSTART+SCSJOBNBR Unique Index

Name	Type	Description
SCSACTLSTART	VARCHAR(254)
SCSLASTUPDATE	TIMESTAMP NOT NULL	Default current timestamp.
SCSINSTREFNUM	BIGINT NOT NULL	Instance number for this run of job.
SCSJOBNBR	BIGINT NOT NULL	This number refers to a job defined in the SCHCONFIG table
SCSPREFSTART	TIMESTAMP NOT NULL
SCSPROGRESS	VARCHAR(254)
SCSPROGRESSMSG	VARCHAR(1000)
SCSREASONCODE	VARCHAR(64)
SCSSTATE	CHAR (2) NOT NULL	State of the scheduled job. I - The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table IF - The scheduled job is rescheduled to run. There was a previous failed attempt to execute the job. R - The scheduled job is running. The job execution start time is recorded in either the SCSACTLSTART column of the SCHSTATUS table or SCHACTIVE table. The SCSQUEUE column indicates which JVM process is running the job. RF - The scheduled job is running. There was a previous failed attempt to execute the job. C - The scheduled job has completed successfully. The job execution finish time is recorded in the SCSEND column of either the SCHSTATUS table or the SCHACTIVE table. CF - The same as state C except there was an exception while executing the scheduled job. The job failed to execute successfully. W - There is a check task command assigned to the scheduled job. This means that before the job is executed, there is a side process that will execute to determine whether the job really needs to be run. This saves the overhead of running a scheduled job when it does not need to be run. (This parameter is mostly used for store level scheduled jobs)
SCSPREFSTART	TIMESTAMP NOT NULL	Preferred start time for this job
SCSACTLSTART	TIMESTAMP	Actual start time for this run of the job
SCSRESULT	CHAR (1)	Result of job: success or fail
SCSQUEUE	VARCHAR (128)	Indicates the job queue. The queue name is of the format hostName:cloneId:applicationType, where the hostName and applicationType components are defined in the SCHCONFIG table and cloneId is generated
SCSEND	TIMESTAMP	End time for this job
SCSATTLEFT	INTEGER	Number of retry attempts left
SCSSEQUENCE	INTEGER	Scheduling policy for this job
SCSINSTRECOV	BIGINT	If this is a retry of a failed job this column refers to the instance of the failed job
TENANT_ID	BIGINT NOT NULL DEFAULT 0	The ID of the tenant in the multi-tenant environment
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
SCSPROGRESSMSG	VARCHAR(1000)	Reserved for IBM internal use only.
SCSPROGRESS	VARCHAR(254)	Reserved for IBM internal use only.
SCSREASONCODE	VARCHAR(64)	Reserved for IBM internal use only.
SCSACTLSTART	TIMESTAMP	Reserved for IBM internal use only.
SCSPREFSTART	TIMESTAMP	Not null.
SCSLASTUPDATE	TIMESTAMP	Not null. Default current timestamp.

Name	Column Names	Type
P_0049	SCSINSTREFNUM	Primary Key
I0001543	SCSPREFSTART+SCSJOBNBR	Unique Index