About audit information of a job

bgs_vb · Post by **bgs_vb** » Wed Jan 07, 2009 7:52 am

While executing a job we are able to see the performance statistics of the job. Since we are able to view the performance statistics of the job for the last run .So this information must be getting stored at some location of the server or in the client system.Can any body tell me that location and how it is being stored.

chulett · Post by **chulett** » Wed Jan 07, 2009 8:11 am

Stored in the repository. What 'performance statistics' are you after? Basically, you'd use the API to retrieve them - either using dsjob from the command line or the various DSGet* routines.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 07, 2009 4:19 pm

Stored in records in the RT_STATUSnnn table for the job, where the job number is nnn. There is no documentation in the public domain that explains the structures that are used - as Craig says you're better off using API functions, mainly DSGetLinkInfo(), to retrieve this information.