x

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.

more ▼

asked Mar 05, 2013 at 07:53 AM in Default

avatar image

limitha
150 6 7 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Any delays?

You can check your jobstatus with (against reporting database, change database name if your reporting database has a non default name):

more ▼

answered Mar 05, 2013 at 09:49 AM

avatar image

raadee
4.5k 12 18 22

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

Mar 05, 2013 at 09:49 AM raadee

No delay. Some times it takes the 10 to 15 mins for file generation.

Mar 05, 2013 at 10:06 AM limitha

If you run the t-sql from the report manually in SMSS, do you encounter the same problem?

Mar 05, 2013 at 10:13 AM raadee

No. If i run the SP from the report manually in SSMS it takes only 4 to 5 sec only.

Mar 05, 2013 at 10:38 AM limitha
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2031
x33
x9

asked: Mar 05, 2013 at 07:53 AM

Seen: 544 times

Last Updated: Mar 08, 2013 at 11:06 AM

Copyright 2017 Redgate Software. Privacy Policy