Wednesday, March 28, 2012

Scheduling once per hour for part of a day

Hi!
I wonder if it is possible in any way to schedule reports to run every hour
each day between 0800 and 1700?
/MattiasSure, select the report from http://yourserver/reports, go to properties and
select "Render this report from an execution snapshot".
THen you may set the execution schedule as you wish..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mattias" <Mattias@.discussions.microsoft.com> wrote in message
news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> Hi!
> I wonder if it is possible in any way to schedule reports to run every
hour
> each day between 0800 and 1700?
> /Mattias|||I still can't see a way of scheduling the report to run once an hour during
just a part of the day as my question was.
I can schedule it to run once per hour 24 hours a day, but not just between
e.g. 0800 and 1700, or am I just dumb?
/Mattias
"Wayne Snyder" wrote:
> Sure, select the report from http://yourserver/reports, go to properties and
> select "Render this report from an execution snapshot".
> THen you may set the execution schedule as you wish..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Mattias" <Mattias@.discussions.microsoft.com> wrote in message
> news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> > Hi!
> >
> > I wonder if it is possible in any way to schedule reports to run every
> hour
> > each day between 0800 and 1700?
> >
> > /Mattias
>
>|||I answered your other post on this question.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MattiasT" <MattiasT@.discussions.microsoft.com> wrote in message
news:846AF338-47C2-44B0-A97D-0BA6C01F0464@.microsoft.com...
> I still can't see a way of scheduling the report to run once an hour
during
> just a part of the day as my question was.
> I can schedule it to run once per hour 24 hours a day, but not just
between
> e.g. 0800 and 1700, or am I just dumb?
> /Mattias
> "Wayne Snyder" wrote:
> > Sure, select the report from http://yourserver/reports, go to properties
and
> > select "Render this report from an execution snapshot".
> > THen you may set the execution schedule as you wish..
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Mattias" <Mattias@.discussions.microsoft.com> wrote in message
> > news:D39C0FF0-5482-4FA4-9B9D-8AF54C44E60E@.microsoft.com...
> > > Hi!
> > >
> > > I wonder if it is possible in any way to schedule reports to run every
> > hour
> > > each day between 0800 and 1700?
> > >
> > > /Mattias
> >
> >
> >

No comments:

Post a Comment