Re: Time limit on an SQR

[Franck Masson <franck.masson@BRIO.COM>]

it is not possible in sqr but at the Operating system level you can set
some limit of a process.
Look to your operating system to set this option .
and some scheduler have also this option.

Franck,

Paul Davison wrote:
>
> Good afternoon.
>
> Our company created a custom panel in PeopleSoft so users can access the
> JRNL_LN table.  The panel allows users to input certain specs, and  when
> run, creates an SQR that is processed through the Process Scheduler.
>
> Is there a way to limit the time an SQR can run?  We have some reports that
> are taking over 2 hours to run (which become way to big and are pretty
> useless).  We want to put in a 30 minute time limit.
>
> Thank you.
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard