Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table name to see jobs informaiton

998266Apr 25 2013 — edited Apr 25 2013

Hi,

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.
So that by looking at that information users will understand procedure satus.

My question is, what is the table name which i need to query to get jobs information(which are already ran)

i have "MANAGE SCHEDULER" access given by admin.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2013

Added on Apr 25 2013

#database-key-features, #plsql, #scheduler

4 comments

1,975 views