My (pull subscription) replication agents allow me to view each agent's job
history and seasson details in the replication monitor (Enterprise Manager).
How I can export this list to examine more closely outside of EM?
TIA,
Set HistoryVerboseLevel to 3. Now your history will not be overwritten, but
you will have a slight performance degradation. Now as you are using pull
the history will be retained on the Subscribers. DTS is locally. History by
default only hangs around 2 days, you might want to set the history
retention period to something larger. Do this by right clicking on
Replication Monitor and selecting Distributor Properties. Click on the
Properties button and set History Retention to something larger.
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
"TCorp" <tcorpus@.hotmail.com> wrote in message
news:e$aY7jeqFHA.2876@.TK2MSFTNGP12.phx.gbl...
> My (pull subscription) replication agents allow me to view each agent's
job
> history and seasson details in the replication monitor (Enterprise
Manager).
> How I can export this list to examine more closely outside of EM?
> TIA,
>
>
Wednesday, February 15, 2012
export session details
Labels:
agents,
database,
details,
enterprise,
export,
jobhistory,
microsoft,
monitor,
mysql,
oracle,
pull,
replication,
seasson,
server,
session,
sql,
subscription,
view
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment