Hi,

Yeah, I ve had something similar to this before.

Is the replication all working correctly?

If I remember correctly, this can happen if you don't remove all the jobs when dropping and...

Thanks for that!

I will have a look.

Cheers..Graeme

Many Thanks Allen.

Graeme

Yes thanks Allen, my investigations have pointed towards this

The AVg Qu Length was about normal and the processor is not working too hard...the...

Absolutely Chris.

I was just interested in any results it might give.

Thanks again

Graeme

Hmmm.....must be me then!

I have found that if there are UDFs in the sql statement or procedure, then the ITW complains....would this be correct.

I guess I'm gonna have to go...

Hi Andy,

I use this script to capture info on job/job step duration

DECLARE @JOBNAME varchar(200)

SET @JOBNAME = 'YoUR Job Name'

SELECT DISTINCT j.name [JOB], jt.Step_ID [StepID],jt.Step_Name [Step],

 SUBSTRING(CAST(jt.Last_Run_Duration AS varchar(10)) ,LEN(CAST(jt.Last_Run_Duration AS varchar(10)))-5,2)...

Mmmm...interesting point Noel,

We have a junior DBA who has been starting the merge agent before it's scheduled start....why?...I'm not sure after thinking about it. I think the thought was to...

Hi,

It's under Refresh Rate and settings...when you right click on an agent.

We have quite a bit of activity when the agent is started. It is scheduled to run for 12...

I would agree with Kenneth here.

A better solution would be, perhaps, to have a second database. You can apply some logic into triggers that will update/insert into the second database....

Go to the Replcation Monitor and expand the agents node.

Click on the Distribution Agent folder.

In the left hand window you should see a list of your agents.

Right click on the...

Hi,

There are many good articles on the web on setting up various configurations of replication. BOL is also good to start with.

Your message is a bit vague. HAve you considered...

Hi,

Is your distribution agent scheduled to run?

Graeme 

Hello again,

After a bit of digging...I have resolved the issue.

For your information :

In TempDB there is a table called MSReplication_Merge_Status, this contains the current status of the agents (surprisingly enough)....

Hi again,

As an addition to my initial message.

I would like to say that the red error circle only appears on the logreader folder...not on any logreader agent.

Very strange!

Thanks....Graeme