KNTA_SERVICES
For internal use only. This table stores definitions of PPM Center background services along with the default intervals and configured intervals for running those services.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KACC_ACCELERATORS_NLS |
ACCELERATOR_ID |
ACCELERATOR_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
SERVICE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
ACCELERATOR_ID |
NULLABLE |
NUMBER |
|
JAVA_CLASS |
NOT NULL |
VARCHAR2(100) |
Class for the service |
USE_SERVICE_CONTROLLER |
NOT NULL |
VARCHAR2(5) |
|
SERVICE_NAME |
NOT NULL |
VARCHAR2(200) |
Name of the service |
RUN_IN_SEPARATE_THREAD |
NOT NULL |
VARCHAR2(1) |
|
LAST_RUN_DATE |
NULLABLE |
DATE |
Date the service last run |
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
|
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
|
JOB_CLASS |
NULLABLE |
VARCHAR2(200) |
Class name of the job for this service. Mostly, 'GenericJob'. A handful of classes have their own Job classes. |
HANDLER_NAME |
NULLABLE |
VARCHAR2(200) |
|
DEFAULT_CRON_EXPRESSION |
NULLABLE |
VARCHAR2(40) |
System cron expression for scheduling the job |
CRON_EXPRESSION |
NULLABLE |
VARCHAR2(40) |
Current cron expression for scheduling the job |
SERVICE_ENABLED |
NULLABLE |
VARCHAR2(1) |
Indicates whether the service is enabled |
TARGET_QUEUE |
NULLABLE |
VARCHAR2(200) |
The JMS queue to which the message is sent. Possible values: LIGHT, HEAVY. |
CURRENT_INTERVAL |
NULLABLE |
NUMBER |
Indicates how often the job should be triggered |
DEFAULT_INTERVAL |
NULLABLE |
NUMBER |
System job interval for this service |
LAST_RUN_INSTANCE_NAME |
NULLABLE |
VARCHAR2(2000) |
Name of the node on which the service last executed. This column gets updated as soon as the service starts executing. Note that the value is likely change in the next execution, since service executions don't have 'node affinity'. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KNTA_SERVICES_U1 |
UNIQUE |
1 |
SERVICE_ID |
SYS_C005198956 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
This table uses no sequences.