This content has been marked as final. Show 4 replies
You can find out from dba_jobs.
1 person found this helpful
995263 wrote:It may be better to simply create a view rather than a new table.
5 jobs are running in my database everyday midnight. to see the status of those jobs i wanted to create a table with required columns(including status) from DBMS scheduler table.
You can query USER_SCHEDULER_JOB_RUN_DETAILS and USER_SCHEDULER_JOB_LOG for that (or their ALL/DBA counterparts).
I am able to access both.
as per your suggestion i will create view by selecting required columns.
my question is what is the difference between both tables? both are giving same data.
which one is better.
my requirement is i wanted see all those 5 procedures status (including history)
my question is what is the difference between both tables?You'll find the necessary details in the documentation :