Database Administration (MOSC)

MOSC Banner

How do I create an OEM job to that will insert the log results to a central database?

edited May 6, 2025 2:54PM in Database Administration (MOSC) 9 commentsAnswered

While searching the community for a solution to my need, I ran across a slightly related question in which there was the comment:

"If you don't want to look at the log results for each job individually you could have the job insert to a central database via DB link …"

My main question here is: "How do I do that?".

Are there any detailed, step-by-step, instructions anywhere? Is there a document/tutorial that might help me figure this out?

I need to gather information across a few hundred databases that will each return dozens, to hundreds, of lines each. I wish to grab those results so that I can run code/logic against them. Being able to select the results from a single table would be great. To be able to save all of the results as a single delimited file would be sufficient. Having to copy/paste from a few hundred log results in OEM is getting to be a real pain and just not sustainable.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center