Hi Everyone,
I have a SnapshotUpdated schedule problem and cannot figure out myself.
I have 10 dashboards, which need to be executed in the morning and shapshotted into SSRS.
Also I need a PDF in a share everyday for each of them.
What I have done -- deployed reports, created shared schedule for 7:00AM, scheduled snapshot for each of the report.
I also created shared folders on the local SQL Server hard drive one folder for each report, and created subscription for each report to save a PDF into the respective share.
I set Trigger to SnapshotUpdated, which is logical.
Problem I am having:
If you leave only one report managed as above it works perfectly. When you have more than one it starts failing to save the PDF.
How it manifests is in two ways:
- in the list view When Run column sometimes does not change for 1-2 out of 10 reports. So it kindof does not execute the shapshot.
- for some reports When Run updates (shapshot is refreshed), but the schedule view still have old Last Run info. So it kindof does not trigger the subscription.
Has anyone had anything similar or knows what might be the problem here?
Cheers,
VAL
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM