Hourly Scheduling

I have reports that I need to run every hour during the "scheduled" working
day.
Meaning between 8am and 8pm. The only way that I can see to do that is to
create one entry for each hour that I want it to run, meaning 12 scheduled
tasks for each report that I want to run in this manner ...
That could become a maintainence nightmare... Anyone got a better way to do
the same thing?
Thanks,
GaryCan't you create a SQL Server Agent Job Which occurs every 1 hour starting at
8AM and ending at 8PM?
HTH
"Gary Stewart" wrote:
> I have reports that I need to run every hour during the "scheduled" working
> day.
> Meaning between 8am and 8pm. The only way that I can see to do that is to
> create one entry for each hour that I want it to run, meaning 12 scheduled
> tasks for each report that I want to run in this manner ...
> That could become a maintainence nightmare... Anyone got a better way to do
> the same thing?
> Thanks,
> Gary
>
>|||You may create a subcscription for that report and choose hourly
schedule.
Gary Stewart wrote:
> I have reports that I need to run every hour during the "scheduled" working
> day.
> Meaning between 8am and 8pm. The only way that I can see to do that is to
> create one entry for each hour that I want it to run, meaning 12 scheduled
> tasks for each report that I want to run in this manner ...
> That could become a maintainence nightmare... Anyone got a better way to do
> the same thing?
> Thanks,
> Gary