November 5, 2012 at 8:10 pm
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
November 6, 2012 at 1:57 am
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
November 6, 2012 at 4:44 am
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