サポートと今すぐチャット
サポートとのチャット

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Using Foglight for PeopleSoft
Exploring the PeopleSoft Dashboards Foglight for PeopleSoft Agents PS_AppMonitor Agent PS_AppServer Agent PS_DB2SQL Agent PS_MSSQL Agent PS_OracleSQL Agent PS_PPM Agent PS_SchedMonitor Agent PS_SchedServer Agent PS_Scheduler Agent Manual Agent Naming Deployment Scenario Procedures
Foglight for PeopleSoft Reference
Views
PS_AppServer Views PS_DB2SQL Views PS_MSSQL Views PS_OracleSQL Views PS_PPM Views PS_SchedServer Views PS_Scheduler Views
Data

PSS_Processes_Hold_List Table View

Purpose
The PSS_Processes_Hold_List table displays the list of the processes that have the status of Hold during the collection period. The details in this view are derived from the RunPrcs Data Table for those processes that have the status of Hold.
Data for Processes in “Hold” status is collected in the QueuePrcs table according to the criteria (age of the processes) entered in the Jobs/Prcs Collection agent property.
 
* 
NOTE: Processes with statuses other than Hold (for example, Pending) that have changed status to “Hold” and are older than the age specified in the agent property are not collected as the original run time is taken into account for computing the age of the processes.
 
Table 50. Description of the PSS_Processes_Hold_List Table View
Data displayed
•
Database Name — The PS database name.
•
Operator ID — The name of the PeopleSoft application user who scheduled the job or process.
•
Process Name — The name of the process.
•
Job Name — The name of the job.
•
Job Number — The number of the job. This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
•
Job Seq — The sequence number of the Job within the job that the process is associated with. This number is zero if the JobNumber is zero or the process submitted through the process scheduler has no job associated with it. For jobs with multiple processes (and a JobNumber not equal to zero), the addition of a JobSeq number to the JobNumber value equals the Process Instance Number assigned by the Process Scheduler.
•
Queue Name — The name of PS Scheduler job queue.
•
Queue Time — The date and time the job queued.
•
Late — How far past the scheduled run time the job is queued, in seconds. If the job has not begun processing, it is the difference between the system time at the time of collection and the run time for the job. If the job has begun processing, it is the difference between the start time and the run time.
Where to go next
n/a

PSS_Processes_ProcessingTime Table View

Purpose
The PSS_Processes_ProcessingTime table displays the processing time in seconds for the processes that have a status of Processing during the current collection period.  
 
Table 51. Description of the PSS_Processes_ProcessingTime Table View
Data displayed
•
Database Name — The PS database name.
•
Operator ID — The name of the PeopleSoft application user who scheduled the job or process.
•
Process Name — The name of the process.
•
Job Name — The name of the job.
•
Job Number — The number of the job. This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
•
Job Seq — The sequence number of the Job within the job that the process is associated with. This number is zero if the JobNumber is zero or the process submitted through the process scheduler has no job associated with it. For jobs with multiple processes (and JobNumber not equal to zero), the addition of a JobSeq number to the JobNumber value equals the Process Instance Number assigned by the Process Scheduler.
•
Class — The job class, for example, SQR, PSJob, Crystal, and so on.
•
Queue Name — The name of PS Scheduler job queue.
•
Processing Time — The amount of time, in seconds, the job takes to process completely. If the job completes successfully during the collection period, the Processing Time is the difference between the end time and the begin time for the job. If the job is in the processing state at the time of collection, the Processing Time is the difference between the system time at the time of collection and the begin time for the job. For jobs that end with other statuses, such as Unsuccessful, the Processing Time is the time from the Begin Time to the time the job ended with that status.
Where to go next
n/a

PSS_Processes_QueuedList Table View

Purpose
The PSS_Processes_QueuedList table view displays the list of the processes that have the status of Queued during the collection period. The details in this view are derived from the QueuePrcs Data Table for those processes that have the status of Queued.
The processes that have the status of queued are waiting to be initiated and subsequently processed by any available process scheduler server that is configured for the PeopleSoft database.
 
Table 52. Description of the PSS_Processes_QueuedList Table View
Data displayed
•
Database Name — The PS database name.
•
Operator ID — The name of the PeopleSoft application user who scheduled the job or process.
•
Process Name — The name of the process.
•
Job Name — The name of the job.
•
Job Number — The number of the job. This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
•
Job Seq — The sequence number of the Job within the job that the process is associated with. This number is zero if the JobNumber is zero or the process submitted through the process scheduler has no job associated with it. For jobs with multiple processes (and JobNumber not equal to zero), the addition of a JobSeq number to the JobNumber value equals the Process Instance Number assigned by the Process Scheduler.
•
Queue Name — The name of PS Scheduler job queue.
•
Queue Time — The date and time the job queued.
•
Late — How far past the scheduled run time the job is queued, in seconds. If the job has not begun processing, it is the difference between the system time at the time of collection and the run time for the job. If the job has begun processing, it is the difference between the start time and the run time.
Where to go next
n/a

PSS_ProcessList Table View

Purpose
The PSS_ProcessList table displays the list of the processes that have the following states during the collection period: Error, UnabletoPost and Unsuccessful.
 
Table 53. Description of the PSS_ProcessList Table View
Data displayed
•
Database Name — The PS database name.
•
Operator ID — The name of the PeopleSoft application user who scheduled the job or process.
•
Process Name — The name of the process.
•
Process Status — The current status description of the process.
•
Job Name — The name of the job.
•
Job Number — The number of the job. This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
•
Job Seq — The sequence number of the Job within the job that the process is associated with. This number is zero if the JobNumber is zero or the process submitted through the process scheduler has no job associated with it. For jobs with multiple processes (and JobNumber not equal to zero), the addition of a JobSeq number to the JobNumber value equals the Process Instance Number assigned by the Process Scheduler.
•
Queue Name — The name of PS Scheduler job queue.
 
Where to go next
n/a
関連ドキュメント
Foglight for PeopleSoft - 5.6.11
Patch Release Notes
Release Notes
User and Reference Guide
Showing 1 to 3 of 3 rows

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択