Report goes into Long Running

Hi All,

We are facing a long running issue with a report. This Report was created almost 5 years back and it was working all fine. But for the past 2 weeks whenever the report is launched by the scheduler it goes into long running. usually this report will run for 1 - 2 mins (as it will pick very few data).

Business View : (F4801 *= F4801T) Join Type : SQL 92 Left Outer Join

What we have analysed so far,

1. This report works fine when we are manually launching it, hence both debugging and log analysis is not doing any good in this case.

2. When the report was long running we tried checking the tables accessed by the report and there is no lock o n the tables as well.