I have designated an operator as the fail-safe operator in SQL Server Management Studio (SSMS). I now wish to change the fail-safe operator to be a different operator. SSMS allows me to make the changes, but after selecting "OK" and re-opening the SQL Server Agent Properties in SSMS, the changes have not been made. Any idea how to change the fail-safe operator? As far as I can tell, there are no stored procedures available, and as I understand it SSMS is already using SMO. Any help would be greatly appreciated.
Thanks
John
Thanks for taking time to report this. I have opened a bug on this.
You can SMO to perform this operation or use SP_MSsetalertinfo .
Thanks,
Gops Dwarak
No comments:
Post a Comment