Share via

why does my 7:45am ssrs subscription run twice - at 2am and 7:45am?

Ijeoma Nmaju 1 Reputation point
2024-09-23T09:26:50.6566667+00:00

I have a data driven subscription set to run at 7:45 am, however, noticed that the report run at 2am and 7:45am. can't seem to know what the problem is. any help will be appreciated. here is my schedule.ssrs

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,770 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,040 questions
Windows 365 Business
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,501 Reputation points
    2024-09-23T10:22:07.44+00:00

    A subscription creates a SQL Server-Agent job for the scheduling.

    Check job history and job details to if there is a second scheduling.

    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 36,511 Reputation points
    2024-09-24T02:43:39.2133333+00:00

    Hi @Ijeoma Nmaju,

    As Olaf said that you may check the SQL Server-Agent job history to see details.

    Also, you may check the subscription of this report to see if it has another subscription or check the caching to see if you have set cache snapshot.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

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.