iverselinger.failsafe-executor.2.0.0.source-code.oracle.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of failsafe-executor Show documentation

Persistent executor service for Java

There is a newer version: 2.1.1

CREATE TABLE FAILSAFE_TASK (
    ID VARCHAR2(36) NOT NULL,
    PARAMETER CLOB,
    NAME VARCHAR2(200) NOT NULL,
    PLANNED_EXECUTION_TIME TIMESTAMP,
    LOCK_TIME TIMESTAMP,
    FAIL_TIME TIMESTAMP,
    EXCEPTION_MESSAGE CLOB,
    STACK_TRACE CLOB,
    RETRY_COUNT NUMBER(4) DEFAULT 0,
    VERSION NUMBER(4) DEFAULT 0,
    CREATED_DATE TIMESTAMP,
    PRIMARY KEY (ID)
);

CREATE INDEX IDX_FAILSAFE_TASK_CREATED_DATE ON FAILSAFE_TASK (CREATED_DATE);

CREATE INDEX IDX_FAILSAFE_TASK_FAIL_TIME ON FAILSAFE_TASK (FAIL_TIME);