select v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = 'JQ' and j.job (+)= v.id2
SELECT V.SID
, V.ID2 JOB
, J.FAILURES
,
LAST_DATE
, SUBSTR(TO_CHAR(LAST_DATE
, 'HH24:MI:SS')
, 1
, 8) LAST_SEC
,
THIS_DATE
, SUBSTR(TO_CHAR(THIS_DATE
, 'HH24:MI:SS')
, 1
, 8) THIS_SEC
,
J.FIELD1 INSTANCE
FROM SYS.JOB$ J
, V$LOCK V
WHERE V.TYPE = 'JQ'
AND J.JOB (+)= V.ID2
|
|
|