Filter
Top Products
Manually Configuring the Database Tables through Bulk Loading 309
To edit the table:
1 Using a text editor, open one of the following files:
1 To load data into an empty table, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/job_delete_cdr_data.txt file.
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/job_delete_cdr_data.tx
t file.
2 Add one row for each scheduled job. For example:
|JOB_ID|JOB_NUMBER|JOB_TO_SUBMIT|JOB_NEXT_RUN|JOB_INTERVAL|D
ELETE_OLD_CDR|DELETE_EXPORTED|ACTIVE_STATUS|SELECT_WHERE_CLA
USE|DESCRIPTION
1||CWDELETE.DELSUPERCDR||SYSDATE+1/(24*12)|1|1|SELECT...WHER
E CONDITION||
Do not set more than one entry to ACTIVE_STATUS=1. Only the record
with ACTIVE_STATUS=1 is submitted.
Assign the job_to_submit as CWDELETE.DELSUPERCDR.
3 Save and close the file.