List Pending Normal Jobs
How to list those pending normal jobs that are still running in oracle?
Script To List Pending Normal Jobs Running
This script will shows the pending normal jobs running (oracle 11i)
in oracle applications
Backend query is always faster than front end query
(fcr.ACTUAL_COMPLETION_DATE - fcr.ACTUAL_START_DATE) *
24 * 60 TIME_MINS,
and fcr.PHASE_CODE = ?P? ? Pending
and fcr.STATUS_CODE = ?I? ? Normal
AND FCR.REQUESTED_BY = FU.USER_ID
order by fcr.request_id desc;
Have a Oracle Question
Do you have
an Oracle Question?
Certification, Database Administration, SQL, Application, Programming Reference
Application Hints and Tips
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.