Thanks for the help,
Senario 1 : I am sending different clients same report with different data. For Example Client 1 wants reports for xyz region and Client 2 requires for other region.
I have created subscription for report once and then pick subscription Id and ScheduleId from Report server table to manually trigger
I am retrieving all setups from database for clients defined email address and regions. Looping through cursor I am processing those details and updating Email Address and Report Parameters in the [ReportServer].[dbo].[Susbcriptions]
Then using below SQL send PDF to the clients.
exec ReportServer.dbo.AddEvent @EventType='SharedSchedule', @EventData=@ScheduleID
WaitFor Delay 00:00:45 - To allow report processiong to be finished.
Problem1: When Looping through cursor - sometimes client 2 never gets report.
Senario2: For Example, I want to send different license details License 1, License 2 and License 3 to the one client.
Using above method sometimes clients gets License 1 details report 2 times and then License2 details report skipped.
Hope this will provide more information. I am using SQL SERver 2008 Reporting services.