Oracle Reports (MOSC)

MOSC Banner

RW_Server_Job_Queue Table

edited Nov 11, 2010 10:12PM in Oracle Reports (MOSC) 3 commentsAnswered ✓
I have the "jobStatusRepository" item enabled on my reports server and was thinking about using this table as an audit type table.  Use it to track high usage times, report execution time, ect.  I see in the reports configuration file the item "maxQueueSize" is set to a default value of 1000.  So my table will only hold a maximum of 1000 records.  When it reaches that point it dumps the earliest record and inserts the new one.  How can I maintain a history of this table so that in two years or six months or whenever I can look at this table and get

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