Hi Liatt,
Column which returns values like sucess , failure etc is for displaying the sucess or failure of the Scheduled job.
You need to check for column OBJ_M_DOCATVAR.M_DOCATV_N_PARTIAL
I have put decode for displaying partila result flag.
Note : Every Document present in the repository has its data provider properties stored in the OBJ_M_DOCATVAR table.
Hope it helps. Let me know if you have further questions
SELECT
OBJ_M_DOCATVAR.M_DOCATV_C_DPNAME,
OBJ_M_DOCATVAR.M_DOCATV_N_NBROWS,
decode(OBJ_M_DOCATVAR.M_DOCATV_N_PARTIAL,0,'No Partial results',1,'Partial Results') PartialReultFlag,
New_Time((to_date('12/15/1970','mm/dd/yyyy') + (OBJ_M_DOCATVAR.M_DOCATV_N_REF/86400)),'GMT','CDT'),
OBJ_M_DOCATVAR.M_DOCATV_N_REFDUR/60,
OBJ_M_DOCATVAR.M_SRC_C_NAME,
OBJ_M_DOCUMENTS.M_DOC_C_NAME,
OBJ_M_ACTOR.M_ACTOR_C_NAME,
New_Time((to_date('12/15/1970','mm/dd/yyyy') + (DS_PENDING_JOB.BEGIN_TIME/86400)),'GMT','CDT'),
New_Time((to_date('12/15/1970','mm/dd/yyyy') + (DS_PENDING_JOB.BEGIN_DATE /86400)),'GMT','CDT'),
decode(DS_PENDING_JOB.JOB_STATUS,'0','Success','1','Failure','2','Waiting','3','Running','4','Suspended','1001','Retrying(1)','1002','Retrying(2)','1003','Retrying(3)','1004','Retrying(4)','1005','Retrying(5)','1006','Expired'),
New_Time((to_date('12/15/1970','mm/dd/yyyy') + (DS_PENDING_JOB.Submit_DATETIME /86400)),'GMT','CDT'),
decode(DS_PENDING_JOB.FREQUENCY,'4','Once','6','Once','8','Hourly','10','Hourly','16','Daily','18','Daily','32','Weekly','34','Weekly','64','Monthly','66','Monthly','128','Monthly Interval','130','Monthly Interval','256','User Defined','258','User Defined'),
DS_PENDING_JOB.PRIORITY
FROM
OBJ_M_DOCATVAR,
OBJ_M_DOCUMENTS,
OBJ_M_ACTOR,
DS_PENDING_JOB
WHERE
( OBJ_M_DOCUMENTS.M_DOC_N_ID=DS_PENDING_JOB.DOCUMENT_ID )
AND ( OBJ_M_ACTOR.M_ACTOR_N_ID=DS_PENDING_JOB.USER_SUBMIT_ID )
AND ( OBJ_M_DOCATVAR.M_DOC_N_ID=OBJ_M_DOCUMENTS.M_DOC_N_ID )
JaiGupta (BOB member since 2002-09-12)