Re: Setting Process Scheduler Status to Error

[Tony DeLia <tdelia@EROLS.COM>]

Hi Shawn,
   Here's an example of updating the Process Schedular status to error:

if $Pay_Confirm_Run = 'Y'

    show 'Cannot Run Process, Payroll has already been confirmed.'

    let $prcs_message_parm1 = 'Payroll confirmed'
    let #prcs_run_status    = #prcs_run_status_error
    do Update-Process-Status
    stop

end-if


Look through the PRCSDEF.SQC for additional variable settings such as...

    let #prcs_run_status_error        = 3
    let #prcs_run_status_processing   = 7
    let #prcs_run_status_successful   = 9
    let #prcs_run_status_unsuccessful = 10


                      Tony DeLia


Shawn Robinson wrote:
>
> I have developed an SQR, which runs fine in SQRW and from a Custom Run
> Control Panel.
>
> Upon completion I successfully update the Process Scheduler to a 'Success'
> Status via   do Stdapi-Term
>
> In certain circumstances I want to stop the SQR, see example below, but I'm
> not sure how to update the Process Scheduler Status (to ERROR).
>
> Example:
>
>   if $Pay_Confirm_Run = 'Y'
>     show 'Cannot Run Process, Payroll has already been confirmed.'
>     stop
>   end-if
>
> Any help would be appreciated.
>
> Thanks
>
> Shawn R
> Information Analyst
> EDS Systemhouse Inc.
> Shawn.Robinson@notes.osipc.can.eds.com

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com
http://www.sqrtools.com