Timed data driven subscription are triggering multiple times in a interval of 30 min or 1 hour.

Question

I have triggered timed data driven subscription once with the help of stored procedure. It executes successfully and sent mail to users. Then it is automatically triggering from ssrs reporting server in a interval of 30 min to 1 hours frequently. Untill I disable it from reporting server. What would be the reason of ssrs reporting server triggering subscription mails without actually triggered by Admin. The issue is not with the exchange server. It is triggered by SSRS reporting server and same is logged in log file.

Answer 1

Hi @Atish Yedle Reddy ，
Whether you created the ata driven subscription through the stored procedure or manually in the web portal, it is certain that you have set up the data driven subscription to trigger the subscription every half hour/hour. You can re-create a new data-driven subscription after terminating the subscription, either once or at intervals of hours/days/weeks/months depending on your needs.

Or manage your subscriptions in the web portal. see more:
Create, Modify, and Delete Data-Driven Subscriptions.
Manage a Running Process.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Joyce Shen - MSFT ,

We previously also doing the same and same is working fine for us. Since last one month we are getting duplication issue. We are triggering it with the help of T-SQL because once our EOD is complete we deliver the reports to users. There is no fixed time of EOD completion thus we are triggering with the help of T-SQL.

We faced same issue 3 years ago and we divided the mail id's list into multiple sub list and trigger one by one and that issue got resolved but same is not working now.

Currently this issue is resolved as we are disabling the subscription id's once they triggered on current day. We enable them next day when we trigger with the help of T-SQL Stored procedure.

Thanks for your prompt response with valuable suggestions.

Best Regards,
Atish

Answer 3

Hello @Joyzhao-MSFT ,

Thanks for the update.

We have scheduled subscription once a day with the help of web portal. Please find below snap shot for reference.

We trigger the same with the help of subscription id in SQL stored procedure once in a day, Please find below snapshot for the same.

Once we trigger and it is successful, It is again sending the same in a interval of 30 min or sometimes 1 hour. And it continues until we disable it from web portal.

To track we have written stored procedure where it will disable all the mail id's if mail triggered once in a day, So that if second time it triggered then all mail id's would be disabled and it won't send mail to user id's, But it is not referring this code after first attempt. So it is cleared that it is keep on sending mail in iteration on first request only. There is no second request generated, if it is generated then all mail id's should disabled and mail won't be triggered to anyone. Please find code for disabling the user after first successful mail trigger.

Please find code below how it is selecting mail id's for triggering the mail in subscription,

Thanks in advance.