I am looking something to setup alert notification when sql agent is down, sometimes when windows patch apply or server get rebooted Sql Agent is not restarting even though we have set up Sql Agent properties Auto Restart Sql Server if it stops unexpectedly Auto Restart Sql Server Agent if it stops unexpectedly I have also tried to setup services on Component service on server to at Recovery tab, First Failure Restart the service and also restarted service rebooted but didn't work.
(我正在寻找一些在sql代理关闭时设置警报通知的东西,有时在应用Windows补丁或服务器重新启动时Sql代理没有重新启动,即使我们已设置Sql代理属性,如果它意外停止,也会自动重新启动Sql Server。如果它意外停止,我也曾尝试在服务器的“组件”服务上的“恢复”选项卡上设置服务,“首次失败”重新启动该服务,并且重新启动的服务已重新启动,但没有用。)
Is it any way I can get the alert so i can restart service manually when it's Agent is down it it will trigger to restart the job when Agent it's down. (有什么办法可以获取警报,以便在代理关闭时可以手动重新启动服务,当代理关闭时它将触发重新启动作业。)
Thanks for your help!
(谢谢你的帮助!)
ask by pds translate from so 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…