SRCH_SCHCONFIG

Reserved for HCL internal use. This table contains all scheduled job entries

Column Descriptions:

NameTypeDescription
SCCJOBREFNUMBIGINT NOT NULLJob reference number
SCCHOSTVARCHAR (128)The host name of the instance on which the scheduled job will be run
MEMBER_IDBIGINT NOT NULLOwner of the scheduled job
STOREENT_IDINTEGER NOT NULL DEFAULT 0The store ID of the store for which the scheduled job is running
SCCRECDELAYINTEGER NOT NULL DEFAULT 0Delay in seconds between attempts
SCCRECATTINTEGER NOT NULL DEFAULT 0Retry attempt count
COMMANDVARCHAR (256)The job command name
SCCQUERYVARCHAR (3000)Query string for the scheduled command
SCCSTARTTIMESTAMP NOT NULLScheduled start time for the job
SCCINTERVALTYPECHAR (1) NOT NULL DEFAULT 'S'Unit of time for repeating the job at the interval value
SCCINTERVALINTEGERJob reschedule interval in seconds
SCCPRIORITYINTEGER NOT NULL DEFAULT 0Priority
SCCSEQUENCEINTEGER NOT NULL DEFAULT 0Job sequence number
SCCACTIVECHAR (1) NOT NULL DEFAULT 'A'Job active indicator:
  • A - The scheduled job is active for the next run
  • 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.
  • I - The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table
  • N - The scheduled job is not configured
SCCAPPTYPEVARCHAR (20)Application type
TENANT_IDBIGINT NOT NULL DEFAULT 0The ID of the tenant in the multi-tenant environment
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0047SCCJOBREFNUMPrimary Key