Re: SQR effects on process scheduler

[Anthony Leung-New York <ALeung@RUSSREYN.COM>]

Are you aware that there are two locations where you need to keep a copy of
the same SQR program?

When you execute your sqr program as client, PeopleSoft will look at your
file server for the object. However, if you lauch the same sqr from server
via process schedler  PeopleSoft will look for the object in the server
where the process scheduler is installed. If your process scheduler is
installed in a different box other than the file server, you may run into
the problem you've just discribed.

> -----Original Message-----
> From: Marc Steele [SMTP:msteele@RESOURCEPARTNER.COM]
> Sent: February 18, 1999 1:50 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      SQR effects on process scheduler
>
> For all you PeopleSoft'ers out there.
>
> I am attempting to execute a SQR on the server via process scheduler.
> However, the SQR (or Process Scheduler) seems to hang when the process is
> initiated (it reads initiated until canceled).  The SQR executes to
> completion when I execute it as client via process scheduler as well as
> when I run it through SQRW.
>
> Does anyone have any ideas, suggestions, opinions?
>
> I am working with PeopleSoft 7.5, SQRW 4.0, and MS-SQL Server 6.5.
>
> Any assistance is appreciated.
>
>
> Marcus Steele
> Systems Analyst
> reSource Partner