Schedule DB Schema for Oracle

Firenze

I was under the impression that the schedule DB as well as the reporting DB for OpenDeploy can be configured to Oracle.

I have yet to find a reference to the schedule DB schema creation script in the documentation.

I did find the reporting database schema reference in the "Reporting Server Database Schema"

Migrateduser

I was under the impression that the schedule DB as well as the reporting DB for OpenDeploy can be configured to Oracle. I have yet to find a reference to the schedule DB schema creation script in the documentation. I did find the reporting database schema reference in the "Reporting Server Database Schema"

look at the OD 6.2 admin manual page 164 (OD_620_admin_V01_EN.pdf)

"Defining the Scheduler Database"

from that section:

Following are the DDL scripts for creating the database table entries:
[html]CREATE TABLE IWOV_SCHEDULE (PK VARCHAR(128) NOT NULL, SCHEDULED_ITEM
TIMESTAMP NOT NULL, TIME_EXPRESSION VARCHAR(128), END_TIME TIMESTAMP,
REPEAT_COUNT INTEGER, TYPE VARCHAR(128), CALENDAR VARCHAR(128), STATE
VARCHAR(128) NOT NULL, LISTENERS VARCHAR(128), DAYINV VARCHAR(128),
DEPLOYNAME VARCHAR(128), DEPLOYSUFFIX VARCHAR(128), DESCRIPTION
VARCHAR(128), ENDTIME VARCHAR(128), HOURINV VARCHAR(128), KEYVALUES
VARCHAR(128), LOGLEVEL VARCHAR(128), MINUTEINV VARCHAR(128), MONTHDAYS
VARCHAR(128), NO_RECUR VARCHAR(128), OWNER VARCHAR(128), PAD1
VARCHAR(128), PAD2 VARCHAR(128), PAD3 VARCHAR(128), PAD4 VARCHAR(128),
PAD5 VARCHAR(128), PAD6 VARCHAR(128), RECURSET VARCHAR(128), REPAIR
VARCHAR(128), REPEAT VARCHAR(128), STARTDEPLOY BIT, STARTTIME
VARCHAR(128), SYNCH VARCHAR(128), VERIFY VARCHAR(128), WEEKDAY
VARCHAR(128), WEEKINV VARCHAR(128), YEARINV VARCHAR(128))

CREATE TABLE IWOV_SCHEDULE_PK (NEXT_PK VARCHAR(128) NOT NULL)

CREATE TABLE IWOV_QUEUE (PK VARCHAR(128) NOT NULL, NAME_FK
VARCHAR(128) NOT NULL, PRIORITY INTEGER NOT NULL, STATE VARCHAR(128)
NOT NULL, DAYINV VARCHAR(128), DEPLOYNAME VARCHAR(128), DEPLOYSUFFIX
VARCHAR(128), DESCRIPTION VARCHAR(128), ENDTIME VARCHAR(128), HOURINV
VARCHAR(128), KEYVALUES VARCHAR(128), LOGLEVEL VARCHAR(128), MINUTEINV
VARCHAR(128), MONTHDAYS VARCHAR(128), NO_RECUR VARCHAR(128), OWNER
VARCHAR(128), PAD1 VARCHAR(128), PAD2 VARCHAR(128), PAD3 VARCHAR(128),
PAD4 VARCHAR(128), PAD5 VARCHAR(128), PAD6 VARCHAR(128), RECURSET
VARCHAR(128), REPAIR VARCHAR(128), REPEAT VARCHAR(128), STARTDEPLOY
BIT, STARTTIME VARCHAR(128), SYNCH VARCHAR(128), VERIFY VARCHAR(128),
WEEKDAY VARCHAR(128), WEEKINV VARCHAR(128), YEARINV VARCHAR(128))

CREATE TABLE IWOV_QUEUE_NAMES (PK VARCHAR(128) NOT NULL, NAME
VARCHAR(128) NOT NULL, STATE VARCHAR(128) NOT NULL)[/html]