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.