SCHDLRQSTLST_VW

index back

SELECT S.SCHEDULENAME ,S.JOBNAMESRC ,R.MAINJOBINSTANCE , R.RUNSTATUS , R.RQSTDTTM , R.RUNDTTM , R.BEGINDTTM , R.ENDDTTM FROM PSPRCSRQST R , PS_SCHDLDEFN S WHERE R.MAINJOBINSTANCE > 0 AND R.PRCSINSTANCE = R.MAINJOBINSTANCE AND R.SCHEDULENAME= S.SCHEDULENAME AND R.MAINJOBNAME=S.JOBNAMESRC

PeopleSoft Field Name Field Type Column Type Description
SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
ENDDTTM DateTime(26) TIMESTAMP End Date/Time
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20