Friday, February 24, 2012

Agent History?

Hi,
I Have merge replication on SQL 2000, it was setup to run each 1 minute.
I changed the schedule to be continuous instead if 1 minute.
before the change I was able to see all the history in the merge history agent,(an entry each 1 minute).
In the new schedule :All the history is being displayed for one of the merge agent. (I have more then 1 replication)
in another merge agent there's only one entry in the history agent (No data to be merged), When I double click that entry I see all the history.
anyone have any idea how to show all the history in the agent history?
any Help will be appreciated!
Abdu.
A session is basically the period between the merge agent starting and
stopping. The merge history is logged as one entry per session.
So, if you run a continuous merge agent then that is seen as one session
and unfortunately it is logged as one too.
Reinout Hillmann
SQL Server Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
Abdu wrote:
> Hi,
> I Have merge replication on SQL 2000, it was setup to run each 1 minute.
> I changed the schedule to be continuous instead if 1 minute.
> before the change I was able to see all the history in the merge history agent,(an entry each 1 minute).
> In the new schedule :All the history is being displayed for one of the merge agent. (I have more then 1 replication)
> in another merge agent there's only one entry in the history agent (No data to be merged), When I double click that entry I see all the history.
> anyone have any idea how to show all the history in the agent history?
> any Help will be appreciated!
> Abdu.
>

No comments:

Post a Comment