Re: Process Scheduler ques else delete

[Pamela Lantzy <PLantzy@UAMAIL.ALBANY.EDU>]

Yes you can, you must setup a process definition for the 1st SQR just like
the 2nd SQR regardless of what database its running against.  Then you can
create a job definition that contains both process defintions.

-----Original Message-----
From: Noonan, Marybeth [mailto:MNoonan@MFS.COM]
Sent: Friday, July 07, 2000 12:23 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Process Scheduler ques else delete


Hi,
Environ: Oracle 8.05, Sqr 4.2.3,ptolls 7.54, psapps 7.52,2 tier,server unix
I want to schedule 2 sqr programs to run automatically m-f at a designated
time, there ae no control arguments that need to be entered.  The first SQR
selects rows from ()NON-PEOPLESOFT)  Oracle Tables , the 2nd sqr inserts
rows into a PSOFT Oracle table & must run after 1st prog.
My question can we run an SQR within process scheduler that reads NON psoft
tables followed by a 2nd prog that will use PSOFT tables?  I just reread
ptools process scheduler & am confused whether this is possible and/or
difficult to setup?

MaryBeth Noonan
Financial Systems
Ext.  57467
mnoonan@mfs.com