AlwaysON Availability Group and Jobs Part 2

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

    Comments posted to this topic are about the item AlwaysON Availability Group and Jobs Part 2

  • groove_timer

    SSC Journeyman

    Points: 80

    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

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

    craigking75 - Thursday, May 11, 2017 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

    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.

  • chudman

    SSCrazy

    Points: 2422

    Leo,

    Excellent article.  
    Thank you for taking the time to write this up.
    Jeff Bennett

  • Express12

    SSCoach

    Points: 18454

    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!

    BT

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply