Filter
Top Products
300 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
the supercdr_hold table to 0). Only disable holding parameters for
testing purposes.
Manually Running
the Super CDR Delete
Use the cwdelete.delsupercdr procedure to manually delete stored
super CDRs.
To manually delete super CDRs:
1 From a SQL Plus command line, login as the cwbss user.
2 Enter the following script:
set serveroutput on
begin
cwdelete.delsupercdr;
end;
The billing support server deletes the CDRs in the rt_cdr and
rt_super_cdr_status tables.
Manually Scheduling
the Super CDR Delete
Use the cwdelete.job_delete procedure to delete stored super CDRs
and individual CDRs.
To delete super CDRs on a schedule:
1 Add the job to the job_delete_cdr table.
2 Verify the configuration of the job_delete_cdr table.
■ Only the record with ACTIVE_STATUS=1 is submitted. Verify that only
one entry is set to ACTIVE_STATUS=1.
■ Verify that the job_to_submit is CWDELETE.DELSUPERCDR.
■ Verify that the job_interval is set correctly.
3 From a SQL Plus command line, login as the cwbss user.
4 Enter the following script:
set serveroutput on
begin
CWDELETE.JOB_DELETE;
end;
The CDRs are deleted as scheduled. Once the job has run, the billing
support server deletes the CDRs in the rt_cdr and rt_super_cdr_status
tables.
To kill a scheduled job, refer to Manually Dropping a Scheduled Job.