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 NameField TypeColumn TypeDescription
SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
JOBNAMESRCCharacter(8)VARCHAR2(8) NOT NULLJob Name Source
MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess 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
RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19