Program Summary

The batch programs covered in this section include the following:

• Archive and Truncate Purge History Tables (batch_archive_purge_hist.ksh)

• Daily Purge of Foundation Data (dlyprg)

• Refresh Materialized Views (refreshmview.ksh)

• Increment Virtual Business Date (dtesys)

• Load Spreadsheet Templates (ld_iindfiles.ksh and loadods.ksh)

• Pre/Post Helper Processes for Batch Programs (prepost)

• Purge Aged Competitive Pricing Data (cmpprg.pc)

• Purge Asynchronous Job Tables (async_job_status_retry_cleanup.ksh)

• Purge Dashboard Working Tables (rms_oi_purge.ksh)

• Purge Export Data (export_stg_purge.ksh)

• Purge Forecast Data (fcstprg)

• Purge Manage Admin Records (admin_api_purge.ksh)

• Purge Notifications (raf_notification_purge.ksh)

• Retail Business Metrics Calculation (rbm_metrics_calc_job)

• Retain Item Forecast History (rms_oi_forecast_history.ksh)

• Subscription Metrics Update (subscription_metrics_update_job)

• Tax Event Purge (taxevntprg)

• Truncate Table Script (trunctbl.ksh)

Additionally, this chapter contains details on some background processes that can be run as an alternative to jobs that run during the nightly batch cycle:

• Daily Purge of Foundation Data (daily_purge_job)

• Purge Aged Competitive Pricing Data (comp_pricing_purge_job)

• Purge Export Data (data_export_purge_job)

• Purge Forecast Data (forecast_data_purge_job)

• Purge Job Auditing Logs (job_audit_logs_purge_job)

• Tax Event Purge (tax_event_purge_job)