I am trying to figure out how I can create a report that tells me the start and end time of a scheduled report/job.
I am able to view the start time of a report/job using the audit db; however, it does not show the completion time. I does however, show total run time of that job.
Thanks Much
-akustw01
Is it possible to calculate that using some kind of function?
start time + total run time = end time
Its 2 different data types, not sure how to convert dword to time.
I don't know how off the top of my head either or if it's possible. However, if there isn't a field that stores it I don't see what another solution would be.
Perhaps if the runtime is in miliseconds, convert it to days, then look for an add days to timestamp function?
Thats a good idea. Thanks