KNTA_SCHEDULED_TASKS

This table is the primary table owned by the scheduling engine. Every scheduled task has a row in it. For example, when a report is scheduled to run at a later time, a scheduled task is inserted into this table. When the report is completed, the scheduled task is deleted. The workflow engine uses this table in a similar fashion.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

KNTA_SCHEDULED_TASK_RECUR

SCHEDULED_TASK_RECUR_ID

SCHEDULED_TASK_RECUR_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

TASK_DATA_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCHEDULED_TASK_ID

NOT NULL

NUMBER

System-generated identifier

WORKER_CLASS

NOT NULL

VARCHAR2(100)

A fully-qualified WorkerThread subclass name

SCHEDULED_TIME

NOT NULL

DATE

Scheduled time for the task; for a repetitive task, time for the next run

TASK_DATA_ID

NULLABLE

NUMBER

Foreign key to the owner table of this task, for example, knta_report_submissions

GROUP_ID

NULLABLE

NUMBER

Used to group tasks together for serial execution

SCHEDULED_TASK_RECUR_ID

NULLABLE

NUMBER

Foreign key to table KNTA_SCHEDULED_TASK_RECUR; null if non-repetitive

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

PRIORITY_SEQUENCE

NULLABLE

NUMBER

Tasks with smaller priority sequence are run earlier.

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_SCHEDULED_TASKS_N1

NONUNIQUE

1

GROUP_ID

KNTA_SCHEDULED_TASKS_N2

NONUNIQUE

1

TASK_DATA_ID

KNTA_SCHEDULED_TASKS_U1

UNIQUE

1

SCHEDULED_TASK_ID

Sequences

Sequence Name

Sequence Type

KNTA_SCHEDULED_TASKS_S

SCHEDULED_TASK_ID

KNTA_SCHED_GROUP_ID_S

GROUP_ID