replication agent

[jacob94]

I need to have my replication agent retry after a failure occurs. I set the rety interval on a 1 minute setting but the agent never tries to start again? Am I missing something here?

I am pushing a subscription to another PC running all processes at the distributor.

 

[mrdenny]

Add a second schedule to the job in the SQL Agent. Have that schedule run once per minute.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com