myPeopleSoft

PeopleSoft Community Network

Command Line SQR

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?)

7 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Gerald Kimmer on May 22, 2013 at 12:31am

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

▶ Reply

Permalink Reply by Mitchell Mahi on May 22, 2013 at 12:36am

I am a PS developer. We run processes from the workbench often. But I don't have permissions on those tables.

▶ Reply

Permalink Reply by Jae Hunsinger on May 22, 2013 at 1:19am

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

▶ Reply

Permalink Reply by Boyd Sumter on May 29, 2013 at 5:48am

Jae Is correct you should contact your DBA.This would help you to solve your problem.

▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:10pm

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 (captkristen899@gmail.com)