Filter
Top Products
Configuring Accounting Server Database Tables 285
Add one row for each job you want to export CDRs for. For example:
|JOB_ID|JOB_NUMBER|JOB_TO_SUBMIT|JOB_NEXT_RUN|JOB_INTERVAL|F
ILE_NAME|FILE_PATH|COL_DELIMITER|ACTIVE_STATUS|ROW_DELIMITER
|FILE_TYPE|SET_COMPLETE_INTERVAL|SELECT_WHERE_CLAUSE|DESCRIP
TION
1||CWE.OUTPUT||SYSDATE+1|||,|1|||||this is a description|
Assign the JOB_TO_SUBMIT as CWE.OUTPUT.
To resubmit a job that is already in queue, you must delete the job, make
changes to the record, change the ACTIVE_STATUS to 1, and then
resubmit it.
COL_DELIMETER Column delimiter, such as a
comma(,) or pipe (|).
Character
ACTIVE_STATUS 0 = Not active, the job this record
represents will not be executed.
1= Active, the job this record
represents will be executed.
2 = Already submitted.
0,1,2
ROW_DELIMETER Row delimiter N/A
FILE_TYPE Type of file N/A
SET_COMPLETE_INTERVAL This is only used for SuperCDRs. N/A
SELECT_WHERE_CLAUSE A SQL clause that defines special
conditions for selecting the CDRs
from the table.
N/A
DESCRIPTION A description of this job. String
Table 103 job_export_cdrs_data.txt Fields (continued)
Column Name Description Value