SCHEDULABLE_JOB

Definition


The SCHEDULABLE_JOB table contains general information related to jobs

Technical Data


Schema Version 4.5.2
Filegroup BART_DATA
Partitioned No

Summary


The SCHEDULABLE_JOB table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
JOB_ID PK_SCHEDULABLE_JOB         
CLASS_NAME          
STATUS          
RECURRENCE          
POLLING_PERIOD          
DESCRIPTION          

Column Details


JOB_ID

Definition The ID of the job
Type DECIMAL(28), NOT NULL
Primary Key PK_SCHEDULABLE_JOB

CLASS_NAME

Definition The Java class of the job
Type NVARCHAR(2000), NOT NULL

STATUS

Definition The status of the job
Type DECIMAL(1), NOT NULL

RECURRENCE

Definition The next start date of the job
Type NVARCHAR(2000), NULL

POLLING_PERIOD

Definition The next start date of the job in seconds
Type DECIMAL(28), NULL

DESCRIPTION

Definition The description of the job
Type NVARCHAR(2000), NULL

Primary Key Details


PK_SCHEDULABLE_JOB

Column(s) JOB_ID
Filegroup BART_DATA