Re: SQR.LOG

["Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG>]

Doug,

If you are only setting the flag in either the Process Type OR the
Process Definition, I cannot understand why you are getting two files.
If the flag is set in both then they both will be created (as you say)
with results showing in the last one created. If the flag is not used
twice I don't know why you are getting two files.

Wish I knew more, Good Luck

Marc

-----Original Message-----
From: Doug Cottrell [mailto:dcottrell@CCCI.ORG]
Sent: Thursday, March 25, 1999 1:43 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: SQR.LOG


Marc,

Agree that the "-o..." will create the file.  Our mystery is that the
file named <filename>_%%INSTANCE%%.LOG *is* being created - although it
is empty - , as well as the SQR.LOG file.  We want to know who is
creating the uniquely-name file, and how can we get it to use it instead
of SQR.LOG.

We assume SQR or PS ProcessScheduler is creating this, but why isn't
being used?  (We can't find in the Process Definition, or the Process
Jobs Definition, or the SQR.INI or anywhere where this file name is
specified.)

The main reason we're so curious is that we don't have enough room to
add -o on all of our command lines.

Thanks.


>>> "Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG> 03/25/99 11:02AM >>>
UNDER pROCESS SCHEDULER > USE > PROCESS TYPE > SQR REPORT, CLIENT,
ORACLE  > SQR PARMS We use

-oC:\%%DBNAME%%-%%OPRID%%-%%INSTANCE%%.log as an SQR Flag. This names
the sqr.log file uniquely for

each run of an SQR report from Peoplesoft. DBNAME,OPRID and INSTANCE are
all variables that are

available at run time.  I believe this will work for SQR process also.

Marc

-----Original Message-----
From: Doug Cottrell [mailto:dcottrell@CCCI.ORG]
Sent: Thursday, March 25, 1999 9:47 AM
To: Multiple recipients of list SQR-USERS
Subject: SQR.LOG


We are trying to create a unique .LOG file for each SQR process that is
run in the PeopleSoft  Process Scheduler.