I had a issue today that i had to restart SQL agent and i was worried about the replication that it could be out of sync and might be break.
the issue was the database mail was not configured and we are not getting any email notifications for job failures.so i have configured database mail , and enabled sql agent to use database mail profile to notify and that required sql agent restart.
I have restarted the agent, replication agent jobs started as soon as the sql agent started and i double checked the replication agent to make sure, database mail works as needed now ,
hope this helps some one
No comments:
Post a Comment