sysman tables.
264888Mar 24 2008 — edited Oct 14 2009I have quit a few custom database jobs such as refreshes, or purges, or data copies that I run using OEM Grid 10g R2 jobs. In case of a hardware failure since it is just easier to re-install OMS, repository and agents from scratch, I am looking for a SQL that I can run against my current repository and capture the definition of all the reports showing me names when they run and what they run in a form of text that I can print and then just follow if I have to recreate all my jobs on another OEM host. Can someone spell out the SQL or at least the sysman tables that contain this?
Thanks.
Bobby.