question

limitha avatar image
limitha 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.
sql-server-2005ssrs-2005ssrs-subscription
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
raadee avatar image
raadee answered
Any delays? You can check your jobstatus with (against reporting database, change database name if your reporting database has a non default name):
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
No delay. Some times it takes the 10 to 15 mins for file generation.
0 Likes 0 ·
If you run the t-sql from the report manually in SMSS, do you encounter the same problem?
0 Likes 0 ·
No. If i run the SP from the report manually in SSMS it takes only 4 to 5 sec only.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.