Using The Process Scheduler To Send Email amp; FTP Files.ppt

Using The Process Scheduler To Send Email FTP Files  Bradley Smith Computer services University of Central Florida Agenda Changes made to process scheduler to allow for email of log, trace and output files to be emailed back to user Changes made to process scheduler to allow files either to be sent or retrieved from remote sites via ftp Implementation/Testing Objectives Explain why logging into your database server is a bad idea to retrieve log/trace and output files Show how programmers need not know UNIX commands to get SQR’s to send/receive files Show how easy these mods are to place into your environment Introduction Environment Sun E5500, Oracle Database, Student Admin 7.6, Peopletools 7.59 Have used with any 7.5X tools, and should work with 7.0 tools Programmers Little or no knowledge of UNIX Functional users Even less knowledge of UNIX Agenda Changes made to process scheduler to allow for email of log, trace and output files to be emailed back to user Changes made to process scheduler to allow files either to be sent or retrieved from remote sites via ftp Implementation/Testing Requirements Email must deal with MIME attachments Output files, trace files must follow a filenaming convention, (i.e. BRADSMITH_12345.lis) CCLTRGEN.SQR required a minor change because as delivered it uses the same file for each run instead of creating a new file each time. let $FileName = CC || $Letter_Cd || _ || $PRCS_PROCESS_INSTANCE || .ltr Benefits Supports using preferred email address from db if available or sends to OPRID@definedhost Frees up local client machine from processing Large SQR’s run faster on the server If COBOL tracing is turned on, users don’t need to involve the system administrator to send that output to them. Benefits Output/Log files are saved (until deleted), so one can go back and find the information after the run has completed Since the server is running the program, sqr.log file that is typically written when run on the client isn’t los