|
Process Number: 189 |
Revision Date: 11/9/2001 3:04:38 PM |
| Revision #: 1 |
EIS Nightly Update
| Office Responsible: | DCS - District - Computing Services |
Process Type: | internal |
| Position Title: | Sr. Programmer/Analyst | Author: | jmoody | ||
| Cross Trained Staff: | rdoidge | Manager: | dharris | Vice Pres.: | |
| Timeline (Deadlines or Time-Constraints) : |
| nightly |
| What must be done before this process is started: |
| Datatel normal daily processing. |
| Which processes are waiting for this process: |
| EIS workbook requests for data refresh. |
| Source documents or communication with information needed for this process: |
| What is the end-result of this process, or the hand-off |
| EIS files on shmi updated with |
| What steps must be taken independent of the computer system (Manual Process) |
| If sql load fails, run Microsoft sql server Enterprise Manager. Connect to shmi and run "Data Transformation", "Local Packages". Perform the failed package manually. |
| Which steps must be taken on a computer (Electronic Process): |
| On Datatel as cron jobs, at 10:30 pm: S02.EIS.BLD: builds EIS file suite and ftps to shmi. S02.STU.TRK: builds EIS totals data base. S02.UNLOAD.EIS.TOTS: unloads totals and ftps to shmi. On shmi as a scheduled local package, at 11:30: LoadEISAll2002Files |
| Related Documents to Process (e.g. Datatel documentation, Government code books, etc.) |
| Notes (Cautions, suggestions for improvement, etc.) |
|
Process Number: 189 |
Revision Date: 11/9/2001 3:04:38 PM |
| Revision #: 1 |