all reports ran at the same time

  • hi,

    we are on SQL Server 2008 with Reporting Services.

    users reported that all reports, those scheduled daily, weekly and monthly all ran at one time. i'm new to SSRS - where can i begin troubleshooting Reporting Services?

    what could trigger the execution of all reports and ignore the configured the schedule?

    thank you

  • Does this happen every day?

    If so someone has changed the schedules on all of the subscriptions.

    The below will help you find the subscription and then you can troubleshoot from that point onwards

    SELECT

    U.UserName AS SubscriptionOwner,

    C.Path AS ReportPath,

    CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

    S.EventType AS SubscriptionType,

    CONVERT(XML,S.Parameters) AS ReportParameters,

    S.DeliveryExtension AS DeliveryMethod,

    Sc.Name AS ScheduleName,

    Rs.ScheduleID

    FROM

    Subscriptions S

    INNER JOIN

    Users U

    ON

    S.OwnerID = U.UserID

    INNER JOIN

    Catalog C

    ON

    S.Report_OID = C.ItemID

    INNER JOIN

    ReportSchedule RS

    ON

    S.SubscriptionID = RS.SubscriptionID

    INNER JOIN

    Schedule Sc

    ON

    RS.ScheduleID = Sc.ScheduleID

    ORDER BY

    1,2

  • Check if all reports are using a shared schedule.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply