Skip to Main Content

Oracle Database Discussions

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!

How to get database jobs ddl

2879395Sep 6 2015 — edited Sep 6 2015

Hello experts,

I want to get ddls for all database jobs.

1-)Is that possible with "dbms_metadata.get_ddl" and how ?

2-)Is the dba_jobs correct view

3-)What is the diffrences between dba_jobs and dba_scheduler_jobs ? when i execute a "select" on this views, i see that total job number diffrent for this 2 view.

Thank u for advanced interest

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2015
Added on Sep 6 2015
3 comments
1,518 views