scheduled snapshot

I have a report that uses execution snapshots but for some reason the
snapshots don't seem to be executing.
I used 'Render this report from an execution snapshot'
'Use the following schedule to create exection snapshot'
and configured it to create a snapshot everyhour.
but I don't receive a notification every hour. (As a test I wanted it to
notify me of updated snapshots).
The only time it seems to work is when I check 'Create a snapshot of the
report when the apply button is selected'
Is there anything I shoud check to make sure scheduled snapshots work?
JacksonI've been doing some more testing and it seems like it doesn't do scheduling
for odbc connections to access databases. The snapshot schedule works fine
with SQL but doesn't seem to do anything for access databases.
Is there anyway possible to schedule snapshots for an access database?
TIA,
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:essnC6SvFHA.2504@.tk2msftngp13.phx.gbl...
>I have a report that uses execution snapshots but for some reason the
>snapshots don't seem to be executing.
> I used 'Render this report from an execution snapshot'
> 'Use the following schedule to create exection snapshot'
> and configured it to create a snapshot everyhour.
> but I don't receive a notification every hour. (As a test I wanted it to
> notify me of updated snapshots).
> The only time it seems to work is when I check 'Create a snapshot of the
> report when the apply button is selected'
> Is there anything I shoud check to make sure scheduled snapshots work?
> Jackson
>