Hall of Fame
Comments posted to this topic are about the item AlwaysON Availability Group and Jobs Part 2
Thanks for this useful article, as i am currently trying to implement a similar solution for our company moving to Always On (Deliberate spacing on name 🙂 )
Seems to be a couple of typo's in your script
In the sections for Creating the tables HIST_ServerAGRole and HIST_EnableDisableJob there missing a closing parenthis
There's a declare scaler variable missing for @_Source_NM within the uspAG_DisableEnableJobsandAlerts SP
Not sure if it's a typo or not?
Hall of Fame
craigking75 - Thursday, May 11, 2017 3:42 AM
Thanks for the trying solution. Everything was working when I tested it for the article, but looks like when I was copying I did not select complete text. I hope those simple typos are not a big destraction to the implementation idea.
Thank you for taking the time to write this up.
Leo - thanks for documenting this solution. Following up on the typo:
--> There's a declare scaler variable missing for @_Source_NM within the uspAG_DisableEnableJobsandAlerts SP
Do you have a correction for this yet? What should the variable name be AND what is it populated with? thx in advance!
Viewing 5 posts - 1 through 4 (of 4 total)