Print Thread
Find Database Objects should include job source
#38286 06/22/10 04:26 PM
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
bcoulam Offline OP
Member
OP Offline
Member
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
Marco,

I thought I'd asked for this years ago, but seeing how it's not in v8 yet, perhaps I forgot. When using Find Database Objects, the window gives the options to look inside the source code of every database object except DBMS jobs. I'm not yet familiar with 10g's Scheduler, but if jobs in Scheduler are stored elsewhere, they should be included in the search options as well.

As it is, when doing impact analysis, I either query dba_source and then dba_jobs (the "what" column), or I use Find Database Objects, and then amend that search with an additional query on dba_jobs. Would love to see Find Database Objects complete.

Re: Find Database Objects should include job source
bcoulam #38293 06/23/10 11:46 AM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.035s Queries: 15 (0.013s) Memory: 2.4971 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-26 12:51:59 UTC
Valid HTML 5 and Valid CSS