How do I create an OEM job to that will insert the log results to a central database?
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.