Vom Scheduler verwendete SQL-Anweisungen für Sybase ASE

SQL-Anweisungen zum Einrichten der Tabellen

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

CREATE TABLE SCHEDULER_TASKS
(
    "TASK_ID"           integer not null,
    "SPOOLER_ID"        varchar(100) not null,
    "CLUSTER_MEMBER_ID" varchar(100),
    "JOB_NAME"          varchar(255) not null,
    "ENQUEUE_TIME"      datetime,
    "START_AT_TIME"     datetime,
    "PARAMETERS"        text,
    "TASK_XML"          text,
    primary key( "TASK_ID" )
);

CREATE TABLE SCHEDULER_HISTORY
(
    "ID"                integer not null,
    "SPOOLER_ID"        varchar(100) not null,
    "CLUSTER_MEMBER_ID" varchar(100),
    "JOB_NAME"          varchar(255) not null,
    "START_TIME"        datetime not null,
    "END_TIME"          datetime,
    "CAUSE"             varchar(50),
    "STEPS"             integer,
    "EXIT_CODE"         integer,
    "ERROR"             numeric(1),
    "ERROR_CODE"        varchar(50),
    "ERROR_TEXT"        varchar(250),
    "PARAMETERS"        text,
    "LOG"               image,
    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"                   varchar(250) not null,
    "ID"                          varchar(250) not null,
    "SPOOLER_ID"                  varchar(100) not null,
    "DISTRIBUTED_NEXT_TIME"       datetime,
    "OCCUPYING_CLUSTER_MEMBER_ID" varchar(100),
    "PRIORITY"                    integer not null,
    "STATE"                       varchar(100),
    "STATE_TEXT"                  varchar(100),
    "TITLE"                       varchar(200),
    "CREATED_TIME"                datetime not null,
    "MOD_TIME"                    datetime,
    "ORDERING"                    integer not null,
    "PAYLOAD"                     text,
    "INITIAL_STATE"               varchar(100),
    "RUN_TIME"                    text,
    "ORDER_XML"                   text,
    primary key( "SPOOLER_ID", "JOB_CHAIN", "ID" );
);

CREATE TABLE SCHEDULER_ORDER_HISTORY
(
    "HISTORY_ID" integer not null,
    "JOB_CHAIN"  varchar(255) not null,
    "ORDER_ID"   varchar(255) not null,
    "SPOOLER_ID" varchar(100) not null,
    "TITLE"      varchar(200),
    "STATE"      varchar(100),
    "STATE_TEXT" varchar(100),
    "START_TIME" datetime not null,
    "END_TIME"   datetime not null,
    "LOG"        image,
    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"          numeric(9)     not null,
  "STEP"                numeric(9)     not null,
  "TASK_ID"             numeric(9)     not null,
  "STATE"               varchar(100)           ,
  "START_TIME"          datetime       not null,
  "END_TIME"            datetime               ,
  primary key ( "HISTORY_ID","STEP" )
);

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