Re: This may not a related question to SQR

["PHUNG, BINH" <BPHUNG@FINEHOST.COM>]

The main.sqr will be repeating the process as many time as there are files
that it finds.
So won't  i just need to schedule the main.sqr in the Process scheduler and
have it call the other sqr from it?

> -----Original Message-----
> From: Anne-Marie Matula [SMTP:amatula@OIT.UMASS.EDU]
> Sent: Thursday, June 22, 2000 9:03 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: This may not a related question to SQR
>
> More info on this:
>
> Go to the Process Scheduler in PS.  Add a Job Definition that runs the 3
> processes you mentioned in the correct order.
>
> Hope that helps... I suspect however things may be complicated than I
> infer
> from reading your post!  Good luck!
>
> Have a great day!
> Anne-Marie
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Anne-Marie Matula
> Student Information System Project
> Office of Information Technologies
> University of Massachusetts
> 161 Whitmore Administration Building
> Amherst Massachusetts, 01003-8165
> Phone: 413/577-0685
> Fax: 413/545-2150
>
>
> > Date:    Wed, 21 Jun 2000 11:38:01 -0700
> > From:    "Peter R. Lewandowski" <peter.lewandowski@CSUN.EDU>
> > Subject: Re: This may not a related question to SQR.
> >
> > Did you look into using Process Groups within PeopleSoft?  It
> > creates some dependency.
> >
> > Date sent:              Wed, 21 Jun 2000 14:11:32 -0400
> > Send reply to:          sqr-users@list.iex.net
> > From:                   "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> > Subject:                This may not a related question to SQR.
> > To:                     SQR-USERS@list.iex.net
> >
> > > I am using PeopleSoft7.52 on NT with SQL7.0.
> > > Currently we are using the EDI Manager to input vouchers into
> > PeopleSoft.
> > > There are three steps:  step1 is an sqr and it reads the Input file
> and
> > > writes it out to an Output file formated for Step 2. Step 2 is
> > also an sqr
> > > and was developed by PS. It reads the output file from step 1
> > and pushes it
> > > to the staging table. The third step is a PSJOB class which posts or
> > > something like that.
> > > My question is can i automate these steps to be kicked off from one
> sqr.
> > > Have the sqr find the files to be inputed and pass the file name to
> the
> > > steps. Or do i have to insert the filename into the fields of the
> steps?
> > > I plan to use the process scheduler to schedule the main sqr.
> > > Any hint and ideas would be great.
> > > TIA
> > > Binh
> >
> >
> > Pete Lewandowski
> >