w_sql: weekly production job schedule script

Author: Robert Lawson
Environment: Oracle database, HPUX
Description: This script is scheduled weekly jobs via CRON.
Code Listing:

# file name: /home/common/bin/weekly_sql
# purpose: execute weekly sql programs
# whom   : robert lawson  08/16/96

# oracle environment variables
ORACLE_HOME=/u01/home/oracle/product/7.1.4
ORACLE_SID=JIT
export ORACLE_HOME ORACLE_SID

# 08/16/94 roblaw: archive JIT bill_of_material_log
/u01/home/oracle/product/7.1.4/bin/sqlplus jit/erp @/home/common/sql/upd_x_bill_of_material_log

# 08/16/94 roblaw: archive JIT item_trans_log
# /u01/home/oracle/product/7.1.4/bin/sqlplus jit/erp @/home/common/sql/upd_x_item_trans_log

# 08/16/94 roblaw: archive JIT lot_trace
/u01/home/oracle/product/7.1.4/bin/sqlplus jit/erp @/home/common/sql/upd_x_lot_trace

# 08/16/94 roblaw: archive JIT shipping_loc
/u01/home/oracle/product/7.1.4/bin/sqlplus jit/erp @/home/common/sql/upd_x_shipping_loc

# 06/30/97 roblaw: temp for SO reconfigure
/u01/home/oracle/product/7.1.4/bin/sqlplus jit/erp @/home/common/sql/oecu
lp -dca_corp1 /home/common/oracle/oecu.lst