Oracle7 Server Distributed Systems Volume II: Replicated Data
Viewing Job Queue Information
The following data dictionary views display information about jobs in the job queue:
Viewing Information about Job Status and Failed Executions
The following query lists the job number, next execution time, failures, and broken status for each job you have submitted:
SVRMGR> SELECT job, next_date, next_sec, failures, broken
2> FROM user_jobs;
JOB NEXT_DATE NEXT_SEC FAILURES B
---------- --------- -------- ---------- -
9125 01-NOV-94 00:00:00 4 N
14144 24-OCT-94 16:35:35 0 N
41762 01-JAN-00 00:00:00 16 Y
3 rows selected.
Viewing Information about Jobs Currently Running
The following query lists the session identifier, job number, user who submitted the job, and the start times for all currently running jobs:
SVRMGR> SELECT sid, r.job, log_user, r.this_date, r.this_sec
2> FROM dba_jobs_running r, dba_jobs j
3> WHERE r.job = j.job;
SID JOB LOG_USER THIS_DATE THIS_SEC
---------- ---------- -------------------- --------- --------
12 14144 VALERIE 24-OCT-94 17:21:24
25 8536 SCOTT 24-OCT-94 16:45:12
2 rows selected.