SCHEDULABLE_JOB

Definition


The SCHEDULABLE_JOB table contains general information related to jobs

Technical Data


Schema Version 5.0.5
Filegroup BART_DATA
Partitioned No

Summary


The SCHEDULABLE_JOB table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
JOB_ID PK_SCHEDULABLE_JOB       

    The ID of the job
    CLASS_NAME        

      The Java class of the job
      STATUS        

        The status of the job
        RECURRENCE        

          The next start date of the job
          POLLING_PERIOD        

            The next start date of the job in seconds
            DESCRIPTION        

              The description of the job

              Column Details

              The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

              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

              See the primary key information:

              PK_SCHEDULABLE_JOB

              Column(s) JOB_ID
              Filegroup BART_DATA