locked
SSRS Subscriptions Issue RRS feed

  • Question

  • Hello All,

    After the server migration (old-new are identical servers in all aspects including HardWare) the SSRS subscriptions are having issues.

    1. They will run as scheduled but mails are delivered late.

    2. They ran on weekends even though it was not scheduled and not triggered from team.

    3. Job history is not getting updated when subscription run on weekend.


    Workarounds We Did but not solved:

    1. SQL Services restarted.

    2. SSRS restarted.

    3. Manually tested the Subscriptions.

    Please advise.



    Regards, Pradyothana DP. Please Mark This As Helpful if it helps to solve your issue. ========================================================== http://www.dbainhouse.blogspot.in/

    Monday, March 23, 2015 1:12 PM

Answers

  • Hi Pradyothana,

    According to your description, the subscription doesn’t work fine when you migrate it from old server to a new server.

    In your scenario, please use code below to find the corresponding job of the subscription, then check if the schedule both in the subscription and the job is the same.

    use ReportServer;
    Go
    SELECT 
    
          c.Name AS ReportName
    
          , rs.ScheduleID AS JOB_NAME
    
          , s.[Description]
    
          , s.LastStatus
    
          , s.LastRunTime
    
    FROM 
    
          ReportServer..[Catalog] c 
    
          JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID 
    
          JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID
    
          AND rs.SubscriptionID = s.SubscriptionID

    Besides, since you mentioned the email will be delivered on weekends though it hasn’t been scheduled, you could use Reporting Services trace Log File to find which schedule deliveries this report. Please refer to this article: Troubleshooting Subscriptions: Part II, Using the Reporting Services Trace Log File  .

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support



    Tuesday, March 24, 2015 7:47 AM