AntiEarnie
Technical User
I'm not having much luck tracking this down. We run a number of jobs through OEM in oracle 8i. I'm trying to find the table that the job history resides in. Does anyone know where it is? Or what its name is?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What Table is Job History is stored in?
- Thread starter AntiEarnie
- Start date
- Status
- Thread starter
- #3
AntiEarnie
Technical User
I checked in the dba_jobs view but its empty. It looks like there are a few joins used in OEM to create the history tab. What leads I've found so far involove the views and tables under OEMJOBS. Pretty much everything else that is related to jobs was empty. I have yet to find everything that is listed in the history tab though. I'm just hoping there aren't a bunch of decodes used in the background in OEM to generate that tab.
- Status
