Post reply

SSRS data not getting updated data...problem resolves on restarting SQL server agent

  • March 7, 2008 at 5:58 am

    #184859

    SQL 2005 server Reporting services report not showing latest data until SQL server agent is restarted

    I have SQL Server 2005 running reporting services. A stored procedure updates a table every 15 mins with data (Scheduled Job) which is used by the reporting services report to compile an upto date report. The job runs for 10 mins everytime.

    Sometime the report does not show the latest records (today's record) and the only solution we can get around this is schedule a SQL server Agent restart everyday.

    Would somebody let me know if there is any way to approach this issue and find out what the real problem is? Sometimes the report does not give latest results which is causing us to restart SQL sever agent at odd times.

  • March 7, 2008 at 7:54 am

    #786673

    Are you using cached reports?

  • March 7, 2008 at 8:49 am

    #786738

    Yes under 'Execution' it is as under for 5 mins.

    Execution

    Cache a temporary copy of the report. Expire copy of report after a number of minutes: 5

    Is this what you are asking about? Please suggest.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply