Filter
Top Products
Manually Configuring the Database Tables through Bulk Loading 313
To edit the table:
1 Using a text editor, open one of the following files:
■ To load data into an empty table, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/job_merge_cdr_data.txt file.
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/job_merge_cdr_data.t
xt file.
2 Add one row for each scheduled job. For example:
|JOB_ID|JOB_NUMBER|JOB_TO_SUBMIT|JOB_NEXT_RUN|JOB_INTERVAL|C
DR_BEGIN|CDR_END|TIME_OUT_HOUR|ACTIVE_STATUS|SELECT_WHERE_CL
AUSE|DESCRIPTION
1||CWM.MERGECDR||sysdate+1/(24*12)||48|1||CDR_begin and end
need update by BSS, select-clause is in doubt|
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 CWM.MERGECDR
Once a job has been submitted, the job interval cannot be changed. To
change a job interval for a job that is already in queue, delete that job
and then resubmit it.
3 Save and close the file.
ACTIVE_STATUS 0 = Not active, the job this record
represents will not be submitted.
1= Active, the job this record
represents will be submitted.
0,1
SELECT_WHERE_CLAUSE A SQL clause that defines special
conditions for merging cdrs. This
field is not used at this time.
String
DESCRIPTION A description of this job. String
Table 115 job_merge_cdr Fields (continued)
Column Name Description Value