March 21, 2012 at 2:47 pm
Hi All,
I am trying to troubleshoot an issue where when I create a report subscription (Email) the schedule runs the first time and then if I change it to run say 10 minutes later it does not run ans says Pending.
Does anyone know where I could start to look. I do believe that the email setting are correct.
Thanks
Greg
March 22, 2012 at 2:58 am
dont know if this is the right cause but
it might be down to the time it takes for the SQL Agent job to execute, so if it takes longer than 10 minutes to run the job then it cant run the second time as its still executing the first time.
run this in the ReportServer db, it should help you find the job name which is a GUID and then you can see how long it takes to execute the job, if its seconds then I'm at a bit of a stump.
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
March 22, 2012 at 9:24 am
Look in your reporting services database for a view ExecutionLog2. There might be something in there that will give you a clue.
Also I find the Report Server trace files very helpful, difficult to read through, but helpful. You can find them on your server in:
Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply