we never required to change the distribution job, and yes @distribution_job_name is for internal use only :(.

For now I could see the workaround like this.

declare @JobID varchar(1000)

select @JobID=job_id from...

Check the schedule for

"Distribution clean up: distribution" job?

I could do the following:

1. Create a custom profile query timeout and other parameter can be increased and see will that help?

2. create a custom job which runs every hr...

I strongly feel to create a stored procedure and run it on non peak hours to all servers.

also would suggest to do the following to control tlog size

1. simple recovery...

As I understand your question, you want to setup the distribution job name and schedule, which can be setup in

sp_addsubscription

please see BOL for options.

I think option

@distribution_job_name & @frequency......

see my comments in bold...

I have multiple databases (with the same structure but the data may be different) distributed in many locations. Now, I want to collect all that distributed...

you can add article using

sp_addarticle

HTH

vinay

http://rdbmsexperts.com/Blogs/

Hi sqlnsg,

I tweet Gail Shaw to look on to your issue, she is expert on performance tunning.

also tweet Jonathan...

Lets see.

Thanx.

Vinay

I could feel that you have to work on configuration your file system.

1. Use as much number of tempdb files as of your cpu.

2. separate your tempdb file...

Please check the following:

1. You have to check the IO of the database you are using most. -- try to load balance.

2. What time is this issue happening. if...

I apologize for my english. I was in hurry while posting the QOD, the only thing I would like to share was my experience on replication that when we uninstall...

Thanks ALZDBA,

can you please brief about:

"Maybe one of your processes keeps a permanent lock on one of your objects."

also how can be "deadlock happen" as reindex is run during maintainance...

DBCC CHECKDB ( 'DBName' ) WITH ALL_ERRORMSGS

runs successfully no error.

Any suggesions?

try sp_scriptpublicationcustomprocs

http://support.microsoft.com/default.aspx?scid=kb;EN-US;299903

have you checked the security access of distributor agent....

also have you created a custom stored procedures for replication insert. "sp_MSins_dbot_tableName"

try to create this sp at subsriber.

HTH

Vinay