Hi All,
Thanks for all your valuable inputs.
Concluding the case as blow.
Problem
Scheduled reports
- Are not covering the expected time frame (For example: Expected to cover at 00:00 yesterday - 00:00 today, but instead covers a few minutes later, i.e. 00:02 yesterday - 00:02 today).
- Are missing data, which falls into the interval that is not covered.
- Which scheduled to run late, actually runs the next day.
Cause
This is by design.
Scheduled reports are not meant to cover the exact time, as they are designed to cover the time specified from the time they were actually run.
ie. If the report was run late and was supposed to cover a 24 hour interval, it will cover the 24 hour interval from the time it was run.
It will also be scheduled to run, at best, 24 hours in the future from the time it was run.
i.e. If it was run two minutes late, next time, at best, it will run two minutes late.
Reasons for this, some other reports that were scheduled to run at the same time, may be running or replication is happening or even liveupdate running at the time.
Because if one process is running on the database, it would have locked the database, so that the other process cannot read (initiate action) and thus, would have to wait until the current process ended.
Solution
A workaround to this would be, if using a (Microsoft - SQL DB) MSSQL database, then the logs can be parsed via IT Analytics.
# Inputs from TECH173856
Regards
Ajin