Prev: snapshot agent not running
Next: Merge Replication Setup Issue
From: FJY on 18 May 2007 18:58
Hello,

Right now, I have an alert set up in the SQL Server but is it possible for a
C#/C/C++/VB program to detect the replication agent failure? If so, how can
it be done?

Thanks in advance,

Frank
From: Paul Ibison on 19 May 2007 04:09
Something like this should do:
http://www.replicationanswers.com/Downloads/KillRunningJobs.txt
(1 = Executing, 2= Waiting For Thread, 3 = Between Retries, 4 = Idle, 5 =
Suspended, 6 =[obsolete], 7 = PerformingCompletionActions)
HTH,
Paul Ibison


From: Hilary Cotter on 25 May 2007 07:42
query the repl_errors table in the distirbution database.

select name, Publisher=p.srvname, publisher_db, publication,
Subscriber=s.srvname, subscriber_db, MSdistribution_history.time, comments,
error_type_id,source_type_id, source_name, error_code,error_text from
MSdistribution_history
join msrepl_errors on MSdistribution_history.error_id=msrepl_errors.id
join msdistribution_agents on
msdistribution_agents.id=MSdistribution_history.agent_id
join master.dbo.sysservers as p on p.srvid=publisher_id
join master.dbo.sysservers as s on s.srvid=publisher_id
order by 1



--
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
"FJY" <FJY(a)discussions.microsoft.com> wrote in message
news:1F219C21-2032-422F-AC54-C0D5BBC15CAA(a)microsoft.com...
> Hello,
>
> Right now, I have an alert set up in the SQL Server but is it possible for
> a
> C#/C/C++/VB program to detect the replication agent failure? If so, how
> can
> it be done?
>
> Thanks in advance,
>
> Frank


 | 
Pages: 1
Prev: snapshot agent not running
Next: Merge Replication Setup Issue