Wednesday, March 21, 2012

Scheduled snapshots not showing up

I have set a report to render from a snapshot (Properties>Execution). I have
also set up a subscription that emails the report to me.
I am receiving the report via email based on the designated schedule (SQL
Agent is running). However, when I look at the report history, I only see one
snapshot, which is one that I manually created.
Can anyone explain this to me? I would expect to see a snapshot for every
emailed report that I have received.There's an option to show the execution snapshots in your history section.
Tick that and they should show up from that pointonwards.
I've found the SnapshotUpdated trigger to be a bit flaky so I run to
seperate schedules, one to snaphot and then one to deliver the reports.
Hope this helps,
DF
"DBA72" wrote:
> I have set a report to render from a snapshot (Properties>Execution). I have
> also set up a subscription that emails the report to me.
> I am receiving the report via email based on the designated schedule (SQL
> Agent is running). However, when I look at the report history, I only see one
> snapshot, which is one that I manually created.
> Can anyone explain this to me? I would expect to see a snapshot for every
> emailed report that I have received.

No comments:

Post a Comment