Why on earth would SELECT against dba_jobs return 3 rows and a SELECT against dba_running_jobs return 0 rows?
1. all three jobs are NOT broken (broken=N)
2. There is no WHERE CLAUSE in both queries!
# Number of jobs in dba_jobs concurrently + 1
running is to check running jobs... if there are no jobs running you don see any rows
shows all the jobs you have scheduled at different intervals.
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 !!!!