Transaction Replication And SQL Server Agent Emergency

RVattakunntel used Ask the Experts™
When I had to stop and restart sql agent (to configure mail profile), the replication distribution, log reader and queue reader cannot start.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Cannot start or just didn't start?  

If they just didn't start then you should be able to restart them manually by right-clicking the relevant jobs in the Management->SQL Server Agent->Jobs node in Enterprise Manager and then choosing "Start Job".  If this doesn't work then try stopping and starting the SQL Server.

If the jobs cannot start then please post the error you are getting.


Yes, that is what i had to.  I stopped and restarted the agent and they came back up.  Thanks,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial