Re: [sqr-users] Process scheduler --- group of processes

["Everett Carr" <ECARR@holycross.edu>]

There is another way that is VERY CLEAN.

Assuming the run control parms are the same; Lets say for example, journal 
entry interfaces where you might have 50 differenct interface feeds of 
differing in format but all going into the same tables (journal entry) in 
peoplesoft...


Then a really nice solution is a SINGLE page/panel that has a dropdown that 
lists the 50 different interfaces to choose from.

EACH interface is a separate SQC (sqr include). Through the run contol the USER 
selected module is then loaded "on the fly", at execution time.

So you get to create one page, one menu item one component and an infinite 
number of interface modules.

And the really cool thing about this, is when you add the next interface your 
developement steps are simply: 1 write the sqc and 2 add it to the drop down 
lookup table and yer all done.

Take me about 20 minutes to write and setup an entirely new interface using 
this approach.

>>> chaitanyach@yahoo.com 08/29/05 5:10 PM >>>
Hi Larry,
 
Are the 20 SQRs all so different that you can't just create a run
control and have 1 or a few SQRs where the parameters are different?

what does that means?

Thanks,

Chaitanya.

 

 





Larry Roux <LRoux@syr.edu> wrote:
Yes, you need to create a process defininition for each, and then create
a job.

There is one other way, other than creating a job, but it is VERY BAD
to do this. You could create the process definitions for the 20 SQRs
and then assign them to the PeopleSoft Utilities panel group so you run
them the same as SYSAUDIT. I highly recommend against it.

Are the 20 SQRs all so different that you can't just create a run
control and have 1 or a few SQRs where the parameters are different?




Larry Roux
Syracuse University
lroux@syr.edu 


>>> chaitanyach@yahoo.com 08/29/05 3:55 PM >>>
Hi,
Iam using peoplesoft 8.8, I want to run around 20 sqr programmes to run
serial job run mode i.e one success then proceed to nextone, here is the
issue, I know there are 2 possibilities one is writing driver sqr where
including all sqrs and run them but my sqrs can have same procedure
names or varibles, where I am not suppose to change procedure names or
variale names I take out this option, the 2nd way is grouping the
processes using process scheduler process name, process type, job
definitions etc. Do I need to create each page for each sqr (there are
around 20 SQRs) and attach run_cntl id and group them in component and
and attach to menu, and giving sequrity .... like that or is there any
other way, if there is different way, all steps that I need to follow
let me know please. 

Thanks,
Chaitanya.


---------------------------------
Start your day with Yahoo! - make it your home page 

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

                
---------------------------------
Yahoo! Mail for Mobile
 Take Yahoo! Mail with you! Check email on your mobile phone.

_______________________________________________
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