Rem
Rem $Header: gensvc_tables.sql 24-aug-2005.14:06:16 yxie Exp $
Rem
Rem gensvc_tables.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      gensvc_tables.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    yxie        08/24/05 - yxie_bug-4535347
Rem    yxie        08/17/05 - Created
Rem

----------------------------------------------------------------
-- Service Pending/Past Jobs Details
----------------------------------------------------------------
CREATE TABLE MGMT_GENSVC_JOBS_DETAILS
(   target_guid             RAW(16), 
    operation_guid          RAW(16)         DEFAULT SYS_GUID()   NOT NULL,
    job_id                  RAW(16),
    job_owner               VARCHAR2(256),
    execution_id            RAW(16),
    execution_status        NUMBER,
    submission_timestamp    DATE            NOT NULL,
    last_updated_timestamp  DATE            DEFAULT NULL,
    error_message           VARCHAR2(4000)  DEFAULT ''
)
  STORAGE
    (FREELISTS 4)
  INITRANS 2
  MONITORING;