asked
i am getting the error in multiple subscrptions at a time.My report was not capturing the seconds transactions data?
I have scheduled the multiple subscriptions at every one hour. My problem is report was not capturing the seconds data? Ex: 10.00 AM subscribed. Means data captured 9 am to 10 AM but 9.00.04 Data was not captured.
Any delays? You can check your jobstatus with (against reporting database, change database name if your reporting database has a non default name):
select 'SubnDesc' = s.Description, 'SubnOwner' = us.UserName, 'LastStatus' = s.LastStatus, 'LastRun' = s.LastRunTime, 'ReportPath' = c.Path, 'ReportModifiedBy' = uc.UserName, 'ScheduleId' = rs.ScheduleId, -- This is what you need 'SubscriptionId' = s.SubscriptionID from ReportServer.dbo.Subscriptions s join ReportServer.dbo.Catalog c on c.ItemID = s.Report_OID join ReportServer.dbo.ReportSchedule rs on rs.SubscriptionID = s.SubscriptionID join ReportServer.dbo.Users uc on uc.UserID = c.ModifiedByID join ReportServer.dbo.Users us on us.UserID = s.OwnerId
12 People are following this question.
