Filter
Top Products
Manually Configuring the Database Tables through Bulk Loading 307
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_collect_cdr_data.txt file.
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/job_collect_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
REATE_TIME|ACTIVE_STATUS|CDR_NUM_PER|DESCRIPTION
1||CWU.UPLOAD||sysdate+1/24*12||1|0|set collecting cdr job
running per... period|
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 CWU.UPLOAD.
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.
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
CREATE_TIME The date this entry was created. Date
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
CDR_NUM_PER The number of CDRs to copy per time. If this
field is left blank, the billing support server
copies the maximum CDRs available when job
executes.
Integer
DESCRIPTION A description of this job. String
Table 111 job_collect_cdr Fields
Column Name Description Value