batchserver-cvs

[Suresh <sur...@us...>]

Update of /cvsroot/batchserver/batchserver/bin/dbscripts/oracle
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv19635

Added Files:
	create_job_data_transfer.sql create_job_mgmt_mntr_info.sql 
	create_job_statistics.sql 
Log Message:
no message

--- NEW FILE: create_job_mgmt_mntr_info.sql ---
-- Create table
create table JOB_MGMT_MNTR_INFO
(
  JOB_NAME           VARCHAR2(64) not null,
  JOB_INFO BLOB not null
);
-- Add comments to the columns 
comment on column JOB_MGMT_MNTR_INFO.JOB_NAME
  is 'Name of the job.';
comment on column JOB_MGMT_MNTR_INFO.JOB_MGMT_MNTR_INFO
  is 'Management and monitor information';
-- Create/Recreate primary, unique and foreign key constraints 
alter table JOB_MGMT_MNTR_INFO
  add constraint PK_JOB_MGMT_MNTR_INFO primary key (JOB_NAME);

--- NEW FILE: create_job_statistics.sql ---
-- Create table
create table JOB_STATISTICS
(
  JOB_NAME          VARCHAR2(64) not null,
  JOB_START_TIME    DATE not null,
  JOB_END_TIME      DATE not null,
  JOB_EXIT_CODE     NUMBER not null,
  JOB_EXIT_REASON   VARCHAR2(1024),
  RECORDS_PRCOESSED NUMBER,
  MEMORY_USAGE      NUMBER
);
-- Add comments to the columns 
comment on column JOB_STATISTICS.JOB_NAME
  is 'Job Name';
comment on column JOB_STATISTICS.JOB_START_TIME
  is 'Timestamp when job got started.';
comment on column JOB_STATISTICS.JOB_END_TIME
  is 'Timestamp when job got finished.';
comment on column JOB_STATISTICS.JOB_EXIT_CODE
  is 'Job exit code.';
comment on column JOB_STATISTICS.JOB_EXIT_REASON
  is 'Reason in case of job failure';
comment on column JOB_STATISTICS.RECORDS_PRCOESSED
  is 'Number of records processed.';
comment on column JOB_STATISTICS.MEMORY_USAGE
  is 'Memory used by the job.';
-- Create/Recreate indexes 
create index NUIDX_JOB_STATS on JOB_STATISTICS (JOB_NAME);

--- NEW FILE: create_job_data_transfer.sql ---
-- Create table
create table JOB_DATA_TRANSFER
(
  SOURCE_JOB_NAME      VARCHAR2(64) not null,
  DESTINATION_JOB_NAME VARCHAR2(64) not null,
  JOB_DATA_IDENTIFIER  VARCHAR2(256) not null,
  JOB_DATA             BLOB not null
);
-- Add comments to the columns 
comment on column JOB_DATA_TRANSFER.SOURCE_JOB_NAME
  is 'Source Job Name';
comment on column JOB_DATA_TRANSFER.DESTINATION_JOB_NAME
  is 'Destination Job Name';
comment on column JOB_DATA_TRANSFER.JOB_DATA
  is 'Data to be transferred from source job to destination job.';
comment on column JOB_DATA_TRANSFER.JOB_DATA_IDENTIFIER
  is 'Identifier used to recognize the data.';
-- Create/Recreate primary, unique and foreign key constraints 
alter table JOB_DATA_TRANSFER
  add constraint PK_SRC_DST_JOB_NAME primary key (SOURCE_JOB_NAME,DESTINATION_JOB_NAME,JOB_DATA_IDENTIFIER);