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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Capture DDL for Oracle Scheduled Jobs and job from DBMA_JOBS

rg2Apr 8 2009 — edited Apr 8 2009

I have trying at this for while and now I am stuck...so I need some help or advice.

I am doing a DB migration and I need to capture the DDL for all Oracle Scheduled Jobs as well as DBMS_JOBS. Anyone have a good way?

I took a datapump export last week. Can I run a impdp and capture the DDL for this VIA the sqlfile parameter? If so, how? What would be the script for it. Something like this maybe (par file)?

directory=DP_IMPORT
DUMPFILE=dump1.dmp
SCHEMAS=A,B,C...X,Y,Z
LOGFILE=JOBS.LOG
EXCLUDE=TABLE,INDEX,CONSTRAINT
PARALLEL=4
INCLUDE=JOBS

????

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2009

Added on Apr 8 2009

#general-database-discussions

3 comments

694 views