When I look in the Replication Monitor, I see that my Log Reader Agent is not running. I right click on a publication, and click 'View Log Reader Agent Status' and it says "The proces was successfully stopped"

If i press Start, i get the following message.... It's possible i could of deleted the job 'NAVISIONUPGRADE-Navision4-1' by mistake yesterday... How can i re-create it / what does it do?

TITLE: View Log Reader Agent Status
------------------------------

The agent could not be started.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantStartAgent&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The specified @job_name ('NAVISIONUPGRADE-Navision4-1') does not exist. (Microsoft SQL Server, Error: 14262)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=14262&LinkId=20476
link|improve this question

57% accept rate
do you have any publications setup? are your subscribers getting updates? which sever is running the distribution database? – Nick Kavadias Dec 4 '09 at 12:52
yes, there are 3 publications. the subscribers are not getting updates. the subscriber is the distributor as far as i'm aware. – alex Dec 4 '09 at 13:03
feedback

1 Answer

up vote 0 down vote accepted

I ended up deleted and then re-creating the publication.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.