SERVERNAMEPRCSTYPE1=Low
5=Medium
9=High
PMN_PRCSACTV_VW |
index back |
|---|
| SELECT S.SERVERNAME , S.PRCSTYPE , S.PRCSPRIORITY , A.ITEMCOUNT , S.MAXCONCURRENT FROM PS_SERVERMONITOR A , PS_SERVERCLASS S WHERE A.OBJTYPE = 2 AND S.SERVERNAME = A.SERVERNAME AND S.PRCSTYPE = A.OBJNAME |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| SERVERNAME |
Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| PRCSPRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Process Priority
1=Low 5=Medium 9=High |
| ITEMCOUNT | Number(4,0) | SMALLINT NOT NULL | Item Count |
| MAXCONCURRENT | Number(3,0) | SMALLINT NOT NULL | Maximum Concurrent Processes |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |