Filter
Top Products
284 APPENDIX D: MANUALLY CONFIGURING THE ACCOUNTING SERVER
Assign the JOB_TO_SUBMIT as CWDELETE.delcdr.
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.
Configuring
job_export_cdrs
The Oracle built-in DBMS_JOB package will be used for extracting and
exporting data to flat files. The JOB_NUMBER, JOB_TO_SUBMIT,
JOB_NEXT_RUN, JOB_INTERVAL, and JOB_PARSING parameters are
DBMS_JOB package parameters. The other attributes are different
custom settings.
Place a job into the job queue and it will run on a periodic basis. To
execute a job immediately, it is necessary to have only the
JOB_NUMBER parameter.
Table 103 job_export_cdrs_data.txt 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 type of job, usually a stored
procedure. For example,
CWE.output.
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. A value
of sysdate+1/48 would mean that
the job would run every 30 minutes.
sysdate+Integer
FILE_NAME Output file name String
FILE_PATH To avoid installation errors, the
FILE_PATH must be an existing path
on the Oracle server machine. This
path must be defined in the Oracle
initialization file (init<SID>.ora),
under the UTL_FILE_DIR entry.
Path name
(continued)