Hi!
I wonder if it is possible in any way to schedule reports to run every hour
each day between 0800 and 1700?
--
/MattiasRS does not natively support this. You could modify the Sql Agent job that
is associated with the report. The only problem with doing that is that
everytime the ReportServer service starts it will set the schedule back to
it's original state. If you don't want the service to reset the schedules,
set the IsSchedulingService element in the RSReportServer.config file to
false. However, setting this element will mean RS never checks to ensure
that your schedules are in sync and they could get changed by any admin of
SQL.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MattiasT" <MattiasT@.discussions.microsoft.com> wrote in message
news:41B4404B-218C-4784-BFFB-C12C661BFFE6@.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|||Thank you, this will do for now. Do you know if RS will support this in
future releases?
/Mattias
"Daniel Reib [MSFT]" wrote:
> RS does not natively support this. You could modify the Sql Agent job that
> is associated with the report. The only problem with doing that is that
> everytime the ReportServer service starts it will set the schedule back to
> it's original state. If you don't want the service to reset the schedules,
> set the IsSchedulingService element in the RSReportServer.config file to
> false. However, setting this element will mean RS never checks to ensure
> that your schedules are in sync and they could get changed by any admin of
> SQL.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "MattiasT" <MattiasT@.discussions.microsoft.com> wrote in message
> news:41B4404B-218C-4784-BFFB-C12C661BFFE6@.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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment