오라클 JOB확인

SQL> COLUMN WHAT FORMAT A85 SQL> R 1* select what, broken, failures from dba_jobs WHAT B FAILURES ------------------------------------------------------------------------------------- - dbms_refresh.refresh('"CIMS"."MV_CRWL_DOC"'); N 0 dbms_refresh.refresh('"MAINHOME"."MV_HPTB_CLAWINFO"'); N 0 dbms_refresh.refresh('"XML"."MV_XMTB_ARTICLE_INFO"'); N 0 dbms_refresh.refresh('"XML"."MV_XMTB_PANREGROUP_CONTENT"'); N 0 dbms_refresh.refresh('"XML"."MV_XMTB_PANREGROUP_CONTENT02"'); N 0 dbms_refresh.refr...

원문링크 : 오라클 JOB확인