Time limit on an SQR

[Paul Davison <shadwmst@HOTMAIL.COM>]

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