SQL Server Performance

Create Reports.

Discussion in 'SQL Server 2005 Reporting Services' started by samsqlserver, Sep 8, 2008.

  1. samsqlserver New Member

    I created a database named ReportingDB.
    There is a SQL AGENT job which executes a SQL SCRIPT and extracts data from source database into the ReportingDB. This job runs every 2 hours and takes approximately 10min.
    Using ReportingDB i have to create reports.
    Now my question is, will i be able to create reports from ReportingDB while the job is running.
    If not, can anyone suggest a way to do it.
    Thankyou for your time.
    samsqlserver, Sep 8, 2008
    #2

  2. satya Moderator

    Yes why not, have you tried to do so?
    satya, Sep 15, 2008
    #3

Share This Page