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);
|