Hi All,
Today we observed that SSRS reports were not working for 3 hours when we started looking into the SQL trace to find out what was running on ReportServer database during that time we found that a process "exec ClearScheduleConsistancyFlags" was running for more than 3 hours and during that time no reports were working from UI.
The schedule table has only 1000 rows. So this stored procedure should not take this much time to complete.
I tried to look into the usage of this stored procedure but not able to find any reference. What this SP is, when this stored procedure is called, from where?
Anyone can help here??