Re: Getting Peoplesoft Process Scheduler's process scheduled date

[Tony DeLia <tdelia@EROLS.COM>]

Parijit,
   When you run an SQR through Process Scheduler the STDAPI.SQC (or
PRCSDEF.SQC/PRCSAPI.SQC) updates the Process Monitor (PSPRCSRQST)... You
can access this table (PSPRCSRQST) in your SQR retrieving the
information for your particular PRCSINSTANCE... Some of the fields on
PSPRCSRQST include...

RUNSTATUS   (Set by PRCSAPI.SQC)...
RUNDTTM
RQSTDTTM
LASTUPDDTTM
BEGINDTTM
ENDDTTM
etc....

Take your pick!

                           -Tony DeLia



Parijat Sahai wrote:
>
> I'm sorry everyone. I just forgot to add that I want to retrieve this
> info (scheduled run date) in an SQR program, into a variable.
>
> Any help would be welcome.
>
> >
> >Hi,
> >
> >Is there any way that I can retrieve the date on which an SQR process
> >was scheduled to run, as opposed to the current date? The issue is that
> >if the process was scheduled to run around 11.30pm and, for some reason
> >(a large queue, for example), it actually gets to run after midnight,
> >then I have the wrong date if I look at the current date, coz I want
> the
> >date when it was supposed to run.
> >
> >Anyone got around this issue? At least, it is worth discussing, I feel.
> >
> >Parijat.
> >
> >______________________________________________________
> >Get Your Private, Free Email at http://www.hotmail.com
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com