Replication Agent Errors

--To get Agents that caused Error

SELECT  distinct da.name
FROM   MSpublications pub inner join MSsubscriptions subs
                                                ON pub.publication_id = subs.publication_id
                                inner join MSdistribution_agents da
                                                ON da.id = subs.agent_id
WHERE pub.publication = 'PublicationName'


-- To check the errors
select * from msdb..sysreplicationalerts 

-- Agent Errors
SELECT * FROM sys.messages WHERE message_id in ( 14151)

=================================================================

Message ID	Predefined alert	Condition causing the alert to fire	Enters additional information in msdb..sysreplicationalerts
14150	Replication: agent success	Agent shuts down successfully.	Yes
14151	Replication: agent failure	Agent shuts down with an error.	Yes
14152	Replication: agent retry	Agent shuts down after unsuccessfully retrying an operation (agent encounters an error such as server not available, deadlock, connection failure, or time-out failure).	Yes
14157	Replication: expired subscription dropped	Expired subscription was dropped.	No
20572	Replication: Subscription reinitialized after validation failure	Response job 'Reinitialize subscriptions on data validation failure' reinitializes a subscription successfully.	No
20574	Replication: Subscriber has failed data validation	Distribution or Merge Agent fails data validation.	Yes
20575	Replication: Subscriber has passed data validation	Distribution or Merge Agent passes data validation.	Yes
20578	Replication: agent custom shutdown
22815	Peer-to-peer conflict detection alert	Distribution Agent detected a conflict when it tries to apply a change at a peer-to-peer node.	Yes

I