VIEW: SYS.USER_JOBS

Source

View Text - Preformatted

select j."JOB",j."LOG_USER",j."PRIV_USER",j."SCHEMA_USER",j."LAST_DATE",j."LAST_SEC",j."THIS_DATE",j."THIS_SEC",j."NEXT_DATE",j."NEXT_SEC",j."TOTAL_TIME",j."BROKEN",j."INTERVAL",j."FAILURES",j."WHAT",j."NLS_ENV",j."MISC_ENV",j."INSTANCE" from dba_jobs j, sys.user$ u where
j.priv_user = u.name
and u.user# = USERENV('SCHEMAID')

View Text - HTML Formatted

SELECT J."JOB"
, J."LOG_USER"
, J."PRIV_USER"
, J."SCHEMA_USER"
, J."LAST_DATE"
, J."LAST_SEC"
, J."THIS_DATE"
, J."THIS_SEC"
, J."NEXT_DATE"
, J."NEXT_SEC"
, J."TOTAL_TIME"
, J."BROKEN"
, J."INTERVAL"
, J."FAILURES"
, J."WHAT"
, J."NLS_ENV"
, J."MISC_ENV"
, J."INSTANCE"
FROM DBA_JOBS J
, SYS.USER$ U WHERE J.PRIV_USER = U.NAME AND U.USER# = USERENV('SCHEMAID')