SQL 2000 Replication Status Question

Hello,

I'd like to be able to poll a SQL 2000 subscriber database to obtain the current replication status. For example, I'd like to know when the subscriber is sitting idle (e.g. "waiting for changes..."), when it is actively replicating (e.g. "applying script..."), or when it is in an error state (e.g. "The Merge Agent failed...").

I realize I can query the table MSmerge_history which contain a comments and error_id field that may be useful. However, there is no status field that I could easily code against.

Does anyone have any ideas




Answer this question

SQL 2000 Replication Status Question

  • mattdawg

    hi,

    you can check the sysjobhistory table in the msdb database

    regards,

    joey



  • Casper.ptrsn

    Isn't there a runstatus column in MSmerge_history See BOoks ONline for the possible values, i think 1 = start, 2 = succeed, 3 = in progress, 4 = idle, 5 = retry, 6 = fail.
  • SQL 2000 Replication Status Question