Execution snapshots

Does the scheduler for executing a snapshot just simply not work?
Is there a known issue with this? I've tried everything, daily, weekly, on
and on...the only way i've ever gotten a snapshot to execute ever, is by
checking the "execute a snapshot when the apply button is clicked".
Anyone?
Thanks,
BrianSorry for the obvious question, but is SQL Server Agent started?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"G" <brian.grant@.si-intl-kc.com> wrote in message news:O5way6JrEHA.3172@.TK2MSFTNGP10.phx.gbl...
> Does the scheduler for executing a snapshot just simply not work?
> Is there a known issue with this? I've tried everything, daily, weekly, on
> and on...the only way i've ever gotten a snapshot to execute ever, is by
> checking the "execute a snapshot when the apply button is clicked".
> Anyone?
> Thanks,
> Brian
>|||I've having the same symptoms.
- SQL Server Agent is running
- The tasks that are created in SQL are running successfully
- The reports don't show up in the history and the updates are not
reflected in the snapshot data in the report
Everything looks like it SHOULD be working. No errors in the event log.
Nothing of value I could find in the Execution log. Just no new data.
ARGH.
"Tibor Karaszi" wrote:
> Sorry for the obvious question, but is SQL Server Agent started?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message news:O5way6JrEHA.3172@.TK2MSFTNGP10.phx.gbl...
> >
> > Does the scheduler for executing a snapshot just simply not work?
> >
> > Is there a known issue with this? I've tried everything, daily, weekly, on
> > and on...the only way i've ever gotten a snapshot to execute ever, is by
> > checking the "execute a snapshot when the apply button is clicked".
> >
> > Anyone?
> >
> > Thanks,
> >
> > Brian
> >
> >
>
>