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!

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.

query to get script for dbms_scheduler jobs

734237Sep 20 2010 — edited Oct 1 2010

Hi,

I created 3 dbms_scheduler jobs on customer DB earlier. Now with the latest version of Toad they have, when I try to describe these jobs it gives me an error saying ADMIN MODULE REQUIRED to describe such objects.

I contacted Toad for the same and they asked the customer to purchase ADMIN MODULE which th customer is not willing.

My problem is that I need the scipts of each of these DBMS_SCHEDULER jobs and programs, However I am not able to locate a DATA DICTIONARY that would store the source for each of them like we have for PROCEDURES etc USER_SOURCE data dictionary.

Is anyone aware of any such Data Dictionary or has a quey though which I can retrive Scheduler Jobs and Programs scripts.

Please Help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2010

Added on Sep 20 2010

#database-key-features, #scheduler

2 comments

67,794 views