Perhaps you could embed a "call system" type command that would print the report when the SQR has completed. Another option would be to have your Unix Administrator write a shell script that would run via a cron job and it would look for report files to print, print them, and then rename the file so that you still have it for archive purposes, but it wouldn't be reprinted when the cron job recycles. Philip Latone <platone@MCC.MIRACOSTA.CC.CA.US> on 05/18/2000 12:30:18 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: PeopleSoft/Sqr/Unix/Process Sceduler [.] When I try to run a Cross Reference Window Listing (or any other SQR Report) on the server and a printer output destination of lj925, the report ends up in $PS_HOME/bin under the name lj925. Question: How do you print a server side SQR from unix using Process Scheduler without logging in to unix and issuing a lp command? HPUX 11.0 Oracle 8.0.6 PSFT SA 7.6 Ptools 7.58 Here is a list of valid Unix printers: #lpstat -t scheduler is running system default destination: lj925 device for lj925: /dev/null device for lj970: /dev/null device for lj950: /dev/null device for lj900: /dev/null device for ljlrc: /dev/null Config File: #cat psprcs.cfg [Startup] ;========================================================================= ; Database Signon settings ;========================================================================= DBName=HEDEV DBType=ORACLE OprId=PRCS OprPswd= ConnectId= ConnectPswd= ServerName= [Database Options] ;========================================================================= ; Database-specific configuration options ;========================================================================= ; Please see Chapter "Tuning and Administration", in ; Sybase Installation and Administration Guide for details. SybasePacketSize=512 ; Please see Chapter "Tuning and Administration", in ; Oracle Installation and Administration Guide for details UseLocalOracleDB=0 [Trace] ;========================================================================= ; SQL Trace flags ;========================================================================= ;------------------------------------------------------------------------- ; SQL Tracing Bitfield ; ; Bit Type of tracing ; --- --------------- ; 1 - SQL statements ; 2 - SQL statement variables ; 4 - SQL connect, disconnect, commit and rollback ; 8 - Row Fetch (indicates that it occurred, not data) ; 16 - All other API calls except ssb ; 32 - Set Select Buffers (identifies the attributes of columns ; to be selected). ; 64 - Database API specific calls ; 128 - COBOL statement timings ; 256 - Sybase Bind information ; 512 - Sybase Fetch information TraceSQL=0 [Process Scheduler] ;========================================================================= ; General settings for the Process Scheduler ;========================================================================= LogFence=0 ProgramName=PSRUN_HEDEV PTPUPRCS PrcsServerName=PSUNX PSSQR1=%PS_HOME%/sqr PSSQR2= PSSQR3= PSSQR4= PSSQRFLAGS=-i%PSSQR1%/,%PSSQR2%/,%PSSQR3%/,%PSSQR4%/ -m%PSSQR1%/allmaxes.max -ZI F%PSSQR1%/pssqr.unx Log Directory=%PS_SERVDIR%/logs OutputDirectory=%PS_SERVDIR%/output/ pshe@iceman : /home/pshe/he758/appserv/prcs/HEDEV #
Attachment:
PSPT_PSUNX.stdout
Description: Binary data