Axis RightFax 8.5 Guía de instalación descargar pdf (Pagina 94)

13-18

Note: I_TRANSACTION table’s OUTBOUND5 partition stores tender data. OUTBOUND5

partition will not be truncated by this job; Tender data follows lifecyle of SHIPMENT data

hence it will be deleted by OTM shipment purge process “mark for purge”. If Tender data

needs to be deleted during the shipment purge process, then change the logic configuration

parameter PURGE_TENDER_TRANSACTION to TRUE from the default value of FALSE. It can

also manually purged with sql command “exec domainman.orphan_tender_purge(

<total_minutes>,<batch size>);”

Schedule Jobs at a Different Time

You can specify a different time if you would like, as an optional second parameter. For example, the

following command will have the job run at 2:30am. You can resubmit these jobs whenever you need

to change the runtime, since it will auto-delete the previous job, and create it again with the new

time.

SQL> exec partit.submit_job('WW','02:30');

Job 1164 has been submitted.

It will run next on 13-MAY-2002 02:30

Remove Jobs

If you need to remove the job, you can execute the partit.remove_job procedure:

SQL> EXEC PARTIT.REMOVE_JOB('WW');

PL/SQL procedure successfully completed.

Since the job is submitted as a standard Oracle job, you may want to read Oracle Database

documentation about Oracle Database jobs, and the DBMS_JOB package that we utilize in our

procedures.

If you need to manually run the purge, you can do so by running purge_partitioned_tables.sql logged

in as GLOGOWNER. You will be prompted for the frequency. You may want to run this script if you are

not automating the purge, or if it fails and you would like to run it manually. For example, it can look

like this:

SQL> @purge_partitioned_tables

This routine will truncate the oldest partition for each table that has been identified to be purged at

the inputted frequency. The valid values are 'Q' for quarterly, 'MM' for monthly, or 'WW' for weekly, or

'D' for daily. By purging the old data, it can prepare room for the next week, month, or quarter.

Please enter a frequency (Q, MM, WW, D): MM

Purging partition 2...

Purged partition 2 for table GL_LOGIN_HISTORY

Purged partition 2 for table IE_INROUTE_SERVPROV

Purged partition 2 for table IE_MARKS

Purged partition 2 for table IE_SHIPMENTSTATUS

Purged partition 2 for table IE_SHIPMENT_REFNUM

Purged partition 2 for table IE_SHIP_GROUP_REFNUM

Purged partition 2 for table IE_SS_EQUIPMENT

Purged partition 2 for table IE_SS_REMARK

Purged partition 2 for table IE_SS_STOP

Purged partition 2 for table IE_SS_S_EQUIPMENT

Purged partition 2 for table IE_S_SHIP_UNIT

Purged partition 2 for table IE_S_SHIP_UNIT_LINE

Purged partition 2 for table I_LOG_DETAIL

Purged partition 2 for table I_LOG

Purged partition 2 for table I_LOG_DETAIL

1 2 ... 89 90 91 92 93 94 95 96 97 98 99 ... 105 106

Comentarios a estos manuales

Sin comentarios

Axis RightFax 8.5 Guía de instalación Pagina 94

Comentarios a estos manuales

Relacionado con productos y manuales para Software Axis RightFax 8.5