This table contains all scheduled job entries.
Column Descriptions
| Column Name
| Column Type
| Description
|
| SCCJOBREFNUM
| BIGINT NOT NULL
| Job reference number.
|
| SCCHOST
| VARCHAR(128)
| The host name of the instance on which the scheduled job will be run.
|
| MEMBER_ID
| BIGINT NOT NULL
| Owner of the scheduled job.
|
| STOREENT_ID
| INTEGER NOT NULL DEFAULT 0
| The store ID of the store for which the scheduled job is running.
|
| SCCRECDELAY
| INTEGER NOT NULL DEFAULT 0
| Delay in seconds between attempts.
|
| SCCRECATT
| INTEGER NOT NULL DEFAULT 0
| Retry attempt count.
|
| SCCPATHINFO
| VARCHAR(254) NOT NULL
| Command name.
|
| SCCQUERY
| VARCHAR(3000)
| Query string for the scheduled command.
|
| SCCSTART
| TIMESTAMP NOT NULL
| Scheduled start time for the job.
|
| SCCINTERVAL
| INTEGER
| Job reschedule interval in seconds.
|
| SCCPRIORITY
| INTEGER NOT NULL DEFAULT 0
| Priority.
|
| SCCSEQUENCE
| INTEGER NOT NULL DEFAULT 0
| Job sequence number.
|
| SCCACTIVE
| CHAR(1) NOT NULL DEFAULT 'A'
| Job active indicator.
|
| SCCAPPTYPE
| CHAR(20)
| Application type.
|
| INTERFACENAME
| VARCHAR(254)
| The interface of the check command which indicates whether the scheduled job needs to be executed or not.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|