Nelnet download file

Problem Description :

This is ran everyday at 2:00 PM

Resolution :

1. cd /upgrades/banner/NELNET/banner/

2. cd eodrec_component

3. sftp gord2885@sftp.factsmgt.com

Connecting to sftp.factsmgt.com...

gord2885@sftp.factsmgt.com's password:

4. sftp> mget *

Fetching /ftp/instafacts/gord2885/archive to archive

Cannot download non-regular file: /ftp/instafacts/gord2885/archive

Fetching /ftp/instafacts/gord2885/gordonstate-agr_14060311.dat to gordonstate-agr_14060311.dat

/ftp/instafacts/gord2885/gordonstate-agr_14060311.dat 100% 223KB 223.1KB/s 00:01

5. sftp> rm *.dat

Removing /ftp/instafacts/gord2885/gordonstate-agr_14060311.dat

6. sftp> exit

7. sh eod_reconciliation_process.sh

CHANGE TO LOCAL DIR /upgrades/banner/NELNET/banner/eodrec_component

checking parameters and determining files to process...

Processing EOD Reconciliation files...

NO EOD FILE HAS BEEN PROVIDED AT ALL

SEND EOD REC PROCESS TERMINATION EMAIL

Processing Agreement Reconciliation files...

COPY gordonstate-agr_14060311.dat TO ARCHIVE

RUN SQLLOAD to insert gordonstate-agr_14060311.dat EODREC file into ZNBAGRR

SQL*Loader: Release 11.2.0.2.0 - Production on Thu Jun 5 09:01:43 2014

Commit point reached - logical record count 65

Commit point reached - logical record count 124

SUCCESSFULLY RUN SQLLOAD for file gordonstate-agr_14060311.dat

RUN SQLPLUS TO UPDATE ZNBAGRR table with End of Day filename

SUCCESSFULLY RUN SQLPLUS to update ZNBAGRR with filename gordonstate-agr_14060311.dat

RUN SQLPLUS TO RECONCILE file

ARCHIVE LOG FILES USING JAR

DELETE THE LOG FILES

SEND EOD REC AGREEMENT JOB EMAIL

MOVE gordonstate-agr_14060411.dat data file

8. exit

Revision Date : 6/5/2014