[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
- Subject: Process Scheduler ques else delete
- From: "Noonan, Marybeth" <MNoonan@MFS.COM>
- Date: Fri, 7 Jul 2000 12:23:10 -0400
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