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:

Distribution Agent Error: Syntax error or access violation

I am getting this error in the distribution agent that I setup for
transactional replication. The last command which failed is like "CALL
sp_MSins_CompanyName$Trans_ Sales Entry ("
The table name is lengthy and contains spaces too. I believe this is because
of the spaces in the stored procedure name which is causing the syntax
error.
The problem is, I cant rename the tables to ommit the spaces. Isnt there any
way to rename the stored procedures and relink them with the new name so
that the new renamed procedure should be called rather than system keep on
looking for the procedure with the original name?
If there any solution in SQL for this issue that would be great otherwise I
must have to do some workaround if possible.
Muhammad
When you create your publication you can specify the name of the stored
procedure you wish to use. SQL Server will autogenerate that stored
procedure with the name.
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
"Muhammad Shahzad Saleem" <msaleem@.simplywireless.com> wrote in message
news:uJ9xOIuHHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I am getting this error in the distribution agent that I setup for
>transactional replication. The last command which failed is like "CALL
>sp_MSins_CompanyName$Trans_ Sales Entry ("
> The table name is lengthy and contains spaces too. I believe this is
> because of the spaces in the stored procedure name which is causing the
> syntax error.
> The problem is, I cant rename the tables to ommit the spaces. Isnt there
> any way to rename the stored procedures and relink them with the new name
> so that the new renamed procedure should be called rather than system keep
> on looking for the procedure with the original name?
> If there any solution in SQL for this issue that would be great otherwise
> I must have to do some workaround if possible.
> Muhammad
>