Filter
Top Products
312 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/job_export_supercdr_d
ata.txt file.
2 Add one row for each scheduled job. For example:
|JOB_ID|JOB_NUMBER|JOB_TO_SUBMIT|JOB_NEXT_RUN|JOB_INTERVAL|F
ILE_NAME|FILE_PATH|COL_DELIMITER|ROW_DELIMITER|ACTIVE_STATUS
|SET_COMPLETE_INTERVAL|SELECT_WHERE_CLAUSE|DESCRIPTION
1||CWE.OUTPUT||SYSDATE+1/(24*12)|||||1|||This is desc field|
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 CWE.OUTPUT.
3 Save and close the file.
Configuring
job_merge_cdr
The job_merge_cdr table schedules the job merges CDRs.
Table 115 job_merge_cdr Fields
Column Name Description Value
JOB_ID The unique identifier for the job. Integer
JOB_NUMBER This value is assigned by Oracle, not
by user assignment.
N/A
JOB_TO_SUBMIT The job name, usually a stored
procedure name, such as
CWM.mergecdr.
string
JOB_NEXT_RUN The next date/time the job will be
run.
Date
JOB_INTERVAL A configurable interval at which the
job is run. The minimum value is 5
minutes. A value of sysdate+1
would mean that the job would run
once in 24 hours. A value of
sysdate+1/24 would mean that the
job would run every hour.
sysdate+Integer
CDR_BEGIN Not used. N/A
CDR_END Not used. N/A
TIME_OUT_HOUR The number of hours after which
incomplete calls are marked as
complete.
Integer
(continued)