SQL Reporting Services

Question

Hi,

 

I have created one subscription for a report and For Each user i am updating parameters of the report and manually trigger that subscription via T- SQL. After triggering event system must send email with PDF attachement to the users.I have put delay of 35 seconds in between report. But sometime SSRS Sends duplicate emails and some times it skips one of the report from the queue.

 

Please help

 

Regards