Distribution agent schedule

Hi,
1. I need to configure automatic stop of the distribution agent for
transactional replication and start in 3 hours in order guys could run their
reports on the replicated site. This means that distribution agent should run
all the time except the time 7.00-10.00, stop automatic at 7.00 and start at
10.00. How can I configure that through the schedule in the distribution
agent job settings (agent’s properties)?
2. What another solution could be suggested to run queries without
interrupting continuous work of distribution agent for transactional
replication (pull subscriber)?
1) Right click on your distribution agent, select agent properties,
schedules, and create a reoccurring daily schedule which starts at 10:00 and
stops at 7:00.
2) Have them look at Reporting Services or Analysis Services. These products
may be what they are looking for depending on their requirements.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:7CFF7D5E-F884-4885-8459-6D396E644796@.microsoft.com...
> Hi,
> 1. I need to configure automatic stop of the distribution agent for
> transactional replication and start in 3 hours in order guys could run
> their
> reports on the replicated site. This means that distribution agent should
> run
> all the time except the time 7.00-10.00, stop automatic at 7.00 and start
> at
> 10.00. How can I configure that through the schedule in the distribution
> agent job settings (agent's properties)?
> 2. What another solution could be suggested to run queries without
> interrupting continuous work of distribution agent for transactional
> replication (pull subscriber)?
>
|||1) But what shall I choose in the hours option?
2) Reporting guys are already using Reporting Services. But not in the right
way I guess. Some Reports use multiple joins of huge tables.
"Hilary Cotter" wrote:

> 1) Right click on your distribution agent, select agent properties,
> schedules, and create a reoccurring daily schedule which starts at 10:00 and
> stops at 7:00.
> 2) Have them look at Reporting Services or Analysis Services. These products
> may be what they are looking for depending on their requirements.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Elena" <Elena@.discussions.microsoft.com> wrote in message
> news:7CFF7D5E-F884-4885-8459-6D396E644796@.microsoft.com...
>
>
|||1) In the schedules table, select reoccurring. Click Change, Click daily,
and I'd select occurs every 5 minutes. With a start at 10:00 pm and stop at
7:00 am. Its not clear to me when you want it to start and stop. Can you use
am and pm or military times?
2) I can't comment if they are using it correctly or not. If you/they are
concerned about it, I would post to
microsoft.public.sqlserver.reportingservices
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Elena" <Elena@.discussions.microsoft.com> wrote in message
news:2950DC12-CE3B-48A7-B679-19872DD907C2@.microsoft.com...[vbcol=seagreen]
> 1) But what shall I choose in the hours option?
> 2) Reporting guys are already using Reporting Services. But not in the
> right
> way I guess. Some Reports use multiple joins of huge tables.
> "Hilary Cotter" wrote: