SQL Server Performance Forum – Threads Archive

sql server 2000 – reports scheduling

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

---

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.

---

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

---

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.

---

]]>