Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
I'm using Seagate Info 7 and MS SQL Server 7.
I would like to create dynamical statistics to monitor duration of the reports scheduled by my users : min, max and average duration for a given period.
I have created a script which accesses CI_RUNTIMEIMAGE table in SEAGATE database, and uses CI_STARTTIME and CI_ENDTIME columns to get the infos I need. But for some reports, when I compare start date/end date I can read on Seagate Desktop interface with the infos I get from the SEAGATE database, I notice differences on the end date.
For example, I have scheduled a report on 2001-11-11 5:10 PM which has successfully ended one minute after. However, when I read the SEAGATE database, CI_STARTTIME is correct but CI_ENDTIME gives 2001-11-12 10:27 !
Do you know how I can solve my problem ? Thanks in advance !
I'm using Seagate Info 7 and MS SQL Server 7.
I would like to create dynamical statistics to monitor duration of the reports scheduled by my users : min, max and average duration for a given period.
I have created a script which accesses CI_RUNTIMEIMAGE table in SEAGATE database, and uses CI_STARTTIME and CI_ENDTIME columns to get the infos I need. But for some reports, when I compare start date/end date I can read on Seagate Desktop interface with the infos I get from the SEAGATE database, I notice differences on the end date.
For example, I have scheduled a report on 2001-11-11 5:10 PM which has successfully ended one minute after. However, when I read the SEAGATE database, CI_STARTTIME is correct but CI_ENDTIME gives 2001-11-12 10:27 !
Do you know how I can solve my problem ? Thanks in advance !