Re: SQR to kick off a Process Scheduler job

[Tom Hippensteel <thippens@MAIL.WIN.ORG>]

I am in the middle of the same task for implementation of PeopleSoft Financials.  We are on ver 7.5 and on a UNIX box on an HP9000 with an Oracle DB.  Please give me the details of how you are implementing this task.   Thanks!

Don DeSmith wrote:

> I am not sure of your starting point for the question.
>
> I am also getting a file of journals from a mainframe and loading the journal tables via the PeopleSoft SQR names GLS9002.SQR.  Unless you are quite advanced, I think you would normallly have the PeopleSoft Process Scheduler in charge of running the 3 step (process) job.  My 3 steps are 1) run an SQR to FTP the file to UNIX and pre-process to create a file formatted for GLS9002, 2) run GLS9002, and 3) run an SQR to clean up after GLS9002, ie. rename the data file to indicate GLS9002 was successful.  These 3 "processes" are defined as a "job" within the Process Scheduler so that they run sequentially, and are API-aware so that they can determine success/unsuccess.  We intend to run the journal edit and post from within PeopleSoft after all journals from all sources are ready.  We are running PeopleSoft 7.5 but at least 7.0 could do the same thing.  I don't know when Process Scheduler jobs first appeared.
>
> I suppose one could insert rows in Process Scheduler tables from the outside rather than from a Panel, but it would not be for the faint of heart and would be subject to changes in the next upgrade of PeopleSoft.
>
> If I am on the right track and you want to get into gory detail, you might want to take it "offline" and e-mail me directly.
> If I am on the wrong track you can ignore me.
>
> Thanks
> Don DeSmith
>
> >>> "Parenteau, Brian P." <BPParenteau@CVS.COM> 08/03 3:00 PM >>>
> Hi All,
> Does anyone have an example of an sqr that will kick off a job within the
> Peoplesoft Process Scheduler??  We are trying to automate the General
> Ledger, load, edit and post process.  We are receiving a download file of
> journal entries from the mainframe.  Once that file is written to the UNIX
> server, we want to kick off the 3-step job in Peoplesoft.  I know I have to
> update the request table, but I'm not sure how!
>
> Thanks for the help!!