Page 1 of 1
About audit information of a job
Posted: Wed Jan 07, 2009 7:52 am
by bgs_vb
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.
Posted: Wed Jan 07, 2009 8:11 am
by chulett
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.
Posted: Wed Jan 07, 2009 4:19 pm
by ray.wurlod
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.