[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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