Report Completion Report

[akustw01]

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

[hauge9]

Is it possible to calculate that using some kind of function?

start time + total run time = end time

[akustw01]

Its 2 different data types, not sure how to convert dword to time.

[hauge9]

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?

[akustw01]

Thats a good idea.  Thanks