Filter
Top Products
308 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
Configuring
job_delete_cdr
The job_delete_cdr table schedules the job that deletes/removes data
from the database.
The supercdr_hold table (refer to Configuring supercdr_hold) overrides
any data deletion. If the supercdr_hold table is configured to hold calls
for a certain period of time, the CDRs are held until those conditions are
met. remove the holding period and holding number limits, set both the
HOLDING_PERIOD and NUM_LIMIT fields in the supercdr_hold table to
0.
Table 112 job_delete_cdr Fields
Column Name Description Value
JOB_ID The unique identifier for the job. Integer
JOB_NUMBER This value is assigned by Oracle. N/A
JOB_TO_SUBMIT The job name, usually a stored procedure
name, such as CWDELETE.DELSUPERCDR.
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
DELETE_OLD_CDR Not used. N/A
DELETE_EXPORTED 0 = Do not delete crds that have been
exported.
1 = Delete the cdrs that have been
exported.
0,1
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_CLAU
SE
A SQL clause that defines special
conditions for deleting the cdrs from the
table. This field is not used at this time.
String
DESCRIPTION A description of this job. String