Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: