Share via

SSRS 2017 subsciption is not working, but when the reports are run manually it is working.

B, Mahadevan 20 Reputation points
2023-12-18T18:18:48.1533333+00:00

SSRS 2017:

"We have set up three subscriptions to run every weekday at 8 am. However, a few months ago, they stopped working and the reports are not being sent at the scheduled time. We can only receive the reports when the subscriptions are run manually. What can be the reason for this? and how can we solve this issue?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,012 questions
0 comments
Accepted answer
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff
    2023-12-19T01:33:35.0166667+00:00

    Hi @B, Mahadevan

    Has the schedule used to trigger the subscription expired?

    The subscription page in Reporting Services contains the status of the subscription, and if there is a problem with the subscription, the Reporting Services log will contain details. You can check the trace log, which is generally located at C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

    For more details, you can refer to this documnet: Troubleshoot Reporting Services Subscriptions and Delivery.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.