RE: [sqr-users] RE: Difference between SQR Process and SQR Report

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

You could also create your own process definition types and use them to
differentiate programs; scheduled programs versus user initiated, HR's
programs versus Payroll's, Peoplesoft-delivered versus in-house developed,
etc.  Then the process scheduler's filter can be selected to show one group
of programs or another.

-----Original Message-----
From: Jamie Harris [mailto:JHarris@frederick.edu]
Sent: Friday, August 13, 2004 2:03 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] RE: Difference between SQR Process and SQR Report



I can think of one small difference:

In Peoplesoft 8 land, particularly at the following page:
Home > PeopleTools > Process Scheduler Manager > Use > Server
Definitions  

You can set how many concurrent tasks of each type are allowed by the
process scheduler.  SQR Process, SQR Report and SQR Report for WF
Delivery are all separate entries, so you could have SQR Reports running
at max capacity and an SQR process could still run (or vice versa).  

You can also set the priority level of each process type, so that could
theoretically be different between the three types.


-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> ed_kelly@hotmail.com 8/13/2004 4:39:51 PM >>>
I don't know if this was answered completely or not, but the answer
varies 
depending upon your PeopleSoft Tools release.  If you are on Tools
release 
7.5x or earlier, both type definitions called the SQR compiler
directly, but 
the type definition for SQR Processes did not include the parameters 
Operator ID and Run Control ID (it was left up to the individual
process 
definition to determine if they were necessary); the type definition
for SQR 
Reports did. As of version 8.x, both type definitions call the utility

program PSSQR.EXE (not the compiler) and the two definitions are
identical, 
with both containing the Operator ID and Run Control ID parameters. So
as of 
version 8.x, it makes absolutely no difference which one you use, you
will 
get the exact same result.  From a Philosophical perspective, SQR
Report 
should be use for any type of report program that you create, whereas
SQR 
Process should be used for any type of interface or database update
program.

I hope this is helpful.
Ed Kelly

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users