May 10, 2017 at 11:12 pm
Comments posted to this topic are about the item AlwaysON Availability Group and Jobs Part 2
May 11, 2017 at 3:42 am
Hi Leo,
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?
Thanks
Craig
May 11, 2017 at 5:35 am
craigking75 - Thursday, May 11, 2017 3:42 AMHi Leo,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?Thanks
Craig
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.
May 11, 2017 at 2:28 pm
Leo,
Excellent article.
Thank you for taking the time to write this up.
Jeff Bennett
January 19, 2018 at 6:18 am
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)
You must be logged in to reply to this topic. Login to reply