Vom Scheduler verwendete SQL-Anweisungen für Oracle®

SQL-Anweisungen zum Einrichten der Tabellen

CREATE TABLE SCHEDULER_VARIABLES
(
    "NAME"     varchar2(100) not null,
    "WERT"     integer,
    "TEXTWERT" varchar2(250),
    primary key ( "NAME" )
);

CREATE TABLE SCHEDULER_TASKS
(
    "TASK_ID"           integer not null,
    "SPOOLER_ID"        varchar2(100) not null,
    "CLUSTER_MEMBER_ID" varchar2(100),
    "JOB_NAME"          varchar2(255) not null,
    "ENQUEUE_TIME"      date,
    "START_AT_TIME"     date,
    "PARAMETERS"        clob,
    "TASK_XML"          clob,
    primary key( "TASK_ID" )
);

CREATE TABLE SCHEDULER_HISTORY
(
    "ID"                integer not null,
    "SPOOLER_ID"        varchar2(100) not null,
    "CLUSTER_MEMBER_ID" varchar2(100),
    "JOB_NAME"          varchar2(255) not null,
    "START_TIME"        date not null,
    "END_TIME"          date,
    "CAUSE"             varchar2(50),
    "STEPS"             integer,
    "EXIT_CODE"         integer,
    "ERROR"             numeric(1),
    "ERROR_CODE"        varchar2(50),
    "ERROR_TEXT"        varchar2(250),
    "PARAMETERS"        clob,
    "LOG"               blob,
    primary key( "ID" )
);

CREATE INDEX SCHEDULER_HISTORY_START_TIME on SCHEDULER_HISTORY ("START_TIME"       );
CREATE INDEX SCHEDULER_HISTORY_SPOOLER_ID on SCHEDULER_HISTORY ("SPOOLER_ID"       );
CREATE INDEX SCHEDULER_HISTORY_JOB_NAME   on SCHEDULER_HISTORY ("JOB_NAME"         );
CREATE INDEX SCHEDULER_H_CLUSTER_MEMBER   on SCHEDULER_HISTORY ("CLUSTER_MEMBER_ID");

CREATE TABLE SCHEDULER_ORDERS
(
    "JOB_CHAIN"                   varchar2(255) not null,
    "ID"                          varchar2(255) not null,
    "SPOOLER_ID"                  varchar2(100) not null,
    "DISTRIBUTED_NEXT_TIME"       date,
    "OCCUPYING_CLUSTER_MEMBER_ID" varchar2(100),
    "PRIORITY"                    integer not null,
    "STATE"                       varchar2(100),
    "STATE_TEXT"                  varchar2(100),
    "TITLE"                       varchar2(200),
    "CREATED_TIME"                date not null,
    "MOD_TIME"                    date,
    "ORDERING"                    integer not null,
    "PAYLOAD"                     clob,
    "INITIAL_STATE"               varchar2(100),
    "RUN_TIME"                    clob,
    "ORDER_XML"                   clob,
    primary key( "SPOOLER_ID", "JOB_CHAIN", "ID" )
);

CREATE TABLE SCHEDULER_ORDER_HISTORY
(
    "HISTORY_ID" integer not null,
    "JOB_CHAIN"  varchar2(255) not null,
    "ORDER_ID"   varchar2(255) not null,
    "SPOOLER_ID" varchar2(100) not null,
    "TITLE"      varchar2(200),
    "STATE"      varchar2(100),
    "STATE_TEXT" varchar2(100),
    "START_TIME" date not null,
    "END_TIME"   date not null,
    "LOG"        blob,
    primary key( "HISTORY_ID" )
);

CREATE INDEX SCHEDULER_O_HISTORY_SPOOLER_ID on SCHEDULER_ORDER_HISTORY ( "SPOOLER_ID" );
CREATE INDEX SCHEDULER_O_HISTORY_JOB_CHAIN  on SCHEDULER_ORDER_HISTORY ( "JOB_CHAIN" );
CREATE INDEX SCHEDULER_O_HISTORY_START_TIME on SCHEDULER_ORDER_HISTORY ( "START_TIME" );

CREATE TABLE SCHEDULER_ORDER_STEP_HISTORY
(
  "HISTORY_ID"          number(9)     not null,
  "STEP"                number(9)     not null,
  "TASK_ID"             number(9)     not null,
  "STATE"               varchar2(100)         ,
  "START_TIME"          date          not null,
  "END_TIME"            date                  ,
  primary key ( "HISTORY_ID","STEP" )
);

CREATE TABLE SCHEDULER_CLUSTERS
(
    "MEMBER_ID"              varchar2(100) not null, 
    "SCHEDULER_ID"           varchar2(100) not null, 
    "PRECEDENCE"             integer, 
    "LAST_HEART_BEAT"        integer,
    "NEXT_HEART_BEAT"        integer, 
    "ACTIVE"                 numeric(1),
    "EXCLUSIVE"              numeric(1),
    "DEAD"                   numeric(1),
    "COMMAND"                varchar2(250),
    "HTTP_URL"               varchar2(100),
    "DEACTIVATING_MEMBER_ID" varchar2(100),
    "XML"                    clob, 
    primary key( "MEMBER_ID" )
);