SQL Server Performance

sql server 2000 - reports scheduling

Discussion in 'SQL Server Reporting Services' started by ravi dasari, Nov 8, 2006.

  1. ravi dasari New Member

    Hi,
    I am calling Report Server (the backend web service) from my ASP.Net application to create and schedule reports.
    I am able to schedule reports successfully. But i am unable to update (any info. ) scheduled reports. I mean ,when i try to change the email address in the report previously scheduled, i am unable to do that.
    I could i go about. pls suggest.
    Is there any configuration change needed ( from Report Manager ) or settings needed at the Report Server windows service part or at the IIS end.

    Thanks in Advance.

    Ravi D
  2. satya Moderator

    Are you getting any error and how you are performing this change?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. ravi dasari New Member

    Hi ,

    I am not getting any error . I am performing the change ( of the scheduled report ) by calling the SetDataDrivenSubscriptionProperties method of the web service.

    It's behaving in a strange way. Yesterday , when i tried to change the email Id of the scheduled report , i successed . But when i tried half an hour later, i could n't able to change.

    I even tried today. But c'd n't succeed to change.

    I could n't understand why some time it is succeeding & failing the other time to update schedule for a report.

    Thanks in Advance.
    Ravi D
  4. satya Moderator

    Might check with PROFILER when using this process.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page