sql server 2000 – reports scheduling | SQL Server Performance Forums

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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |