PeopleSoft Community Network
When running a PeopleSoft process from the process scheduler, you can find the process id and the process status at the process monitor. If you run an sqr from the command line (work bench), it does not show up in the process monitor. How do you find the status of an sqr that is still running that was started from the command line (work bench?)
If you started a sqr from command line, it will not show on the process monitor page for sure. Process monitor will show only the processes that were started from run control pages in the application
To find the current status - you may have to go through the back end. Querying tables V$SESSION, V$SQL etc. or use OEM
Contact your dba. DBAs should be able to check and let you know what sql is currently running in the db by the SQR session that you have started from the workstation
Jae Is correct you should contact your DBA.This would help you to solve your problem.
it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (email@example.com)