DBA_JOBS:
shows all the jobs you have scheduled at different intervals.
DBA_JOBS_RUNNING
Just shows the jobs which are running currently..
so You can get the JOB from dba_job_running and with this Job , you can select WHAT from dba_jobs , which finally what exactly running now...
try that now !!!!




Reply With Quote