anumoses
asked on
DBMS_JOB.submit
Is there a way to find out what are the dbmd_jobs running and at what times?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you need to maintain a history of past job executions, then use dbms_scheduler instead of dbms_job (10g and above only)
or, if you stick with dbms_job then you should modify your job scripts to include logging to some table
dbms_job itself won't tell you anymore than the last time it ran and the next time it should run
or, if you stick with dbms_job then you should modify your job scripts to include logging to some table
dbms_job itself won't tell you anymore than the last time it ran and the next time it should run
ASKER
SELECT r.sid, r.job, r.this_date,
r.this_sec, SUBSTR(what,1,40) what
FROM dba_jobs_running r,dba_jobs j
WHERE r.job = j.job;