Question

FME Server Repository Schema


Badge
Hi,

 

 

(currently running FME server 2011 with an oracle repository DB)

 

 

Can any one point me to some metadata around the repository schema, in particular information on the column descriptions, i'd like to generate some reports against the database - but without geussing what the data columns represent.

 

 

I'm strugelling a little to understand the timestamps in the job tables in particular.  i.e when is a job submitted , queued, started, finished and deliverd.  I had assumed it was this order, but the time stamps don't seem to match this assumption.

 

 

Also, anyone got any suggestions for other useful reports to run against the repository information?

 

 

job duration, workbench failure (as opposed to job status), log path are all useful things i've extracted to date, which allow for useful incident managment and proactive capacity mamangement.

 

 

The idea that led to this question was trying to get an understanding on how hard the engines were being run - i.e when were jobs starting to queue.

 

 

any thoughts appreciated,

 

 

Regards,

 

Nick

 

 

 


0 replies

Be the first to reply!

Reply