If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

CRN Audit Tables

Started by tensiodn, 08 Feb 2006 04:09:04 PM

Previous topic - Next topic

tensiodn

Hi Everyone,

Does anyone have any experience working with the reportnet audit tables?  I'm having a challenge figuring our a Job's Start Time and End Time or Start Time and Run Duration.

In the cogipf_runjob table I see a column for cogipf_runtime - however, this is not a valid date - it's simply any interger value.

Any help will be great.

Thanks.


Anthony.

rmark17

The _localtimestamp field is the job start time and the _runtime is the duration in milliseconds.