That's an option but that way would have to ensure the scripts are in
all databases. Also, there is no way to automatically purge jobs from
the job history.
>>> asahoshi_at_infionline.net 7/23/04 9:59:10 AM >>>
Why not register the jobs in OEM and then just select all the databases
as
targets?
> [Original Message]
> From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
> To: <oracle-l_at_freelists.org>; <ORACLE-L_at_IC.SUNYSB.EDU>;
<oracledba_at_lazydba.com>; <oracle-rdbms_at_yahoogroups.com>
> Date: 7/23/2004 9:21:32 AM
> Subject: What OEM table stores the list of databases
>
> I am looking at creating jobs to go against all of our databases.
Since
> they are all registered in OEM, I was hoping to query a OEM table to
get
> all of the database names. Anybody what OEM table this is stored
in.
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jul 23 2004 - 09:09:14 CDT
