Scheduling a Report

Hello,
I am trying to create a schedule to add snapshots of a certain report to
report history.
So in Report Manager, I go to History and create a schedule to to this. In
my understanding, i need to create a job to execute this shedule. So i go to
Enterprise Manager to create a job. But after this i am lost, basically. How
can i reference this schedule when i go to "New Job". Is there any code that
needs to be put in the "New Job" Wizard so that this schedule can be run?
Thanks
SanjeevYou do not go to Enterprise Manager to do this. Do it all from within Report
Manager.
First create your schedule using Site Settings, Manage shared schedules. Do
this if you want to re-use the schedule with other reports.
Next, navigate to the report's folder and bring up its Properties window.
With the Properties window displayed, there is a History link on the left
side of the screen. Check the option to "Use the following schedule to add
snapshots to report history", then specify the schedule underneath.
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> Hello,
> I am trying to create a schedule to add snapshots of a certain report to
> report history.
> So in Report Manager, I go to History and create a schedule to to this. In
> my understanding, i need to create a job to execute this shedule. So i go to
> Enterprise Manager to create a job. But after this i am lost, basically. How
> can i reference this schedule when i go to "New Job". Is there any code that
> needs to be put in the "New Job" Wizard so that this schedule can be run?
> Thanks
> Sanjeev
>
>|||Thanks Charles. That worked
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:3D77E5E5-BAE9-484B-A87C-714EAD5350FC@.microsoft.com...
> You do not go to Enterprise Manager to do this. Do it all from within
> Report
> Manager.
> First create your schedule using Site Settings, Manage shared schedules.
> Do
> this if you want to re-use the schedule with other reports.
> Next, navigate to the report's folder and bring up its Properties window.
> With the Properties window displayed, there is a History link on the left
> side of the screen. Check the option to "Use the following schedule to add
> snapshots to report history", then specify the schedule underneath.
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> Hello,
>> I am trying to create a schedule to add snapshots of a certain report to
>> report history.
>> So in Report Manager, I go to History and create a schedule to to this.
>> In
>> my understanding, i need to create a job to execute this shedule. So i go
>> to
>> Enterprise Manager to create a job. But after this i am lost, basically.
>> How
>> can i reference this schedule when i go to "New Job". Is there any code
>> that
>> needs to be put in the "New Job" Wizard so that this schedule can be run?
>> Thanks
>> Sanjeev
>>

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.

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
>