Always on and Ola Hallengren SQL Agent Jobs.

• Tac11

  SSCertifiable

  Points: 6980

  More actions

  August 29, 2019 at 6:26 pm

  #3675533

  Hi experts,

  What's the best way to configure Ola Hallengren maintenance jobs on Sql Angent? On secondary replica I can setup a step 'when replica is secondary then quit" but how about alerts which will triggers in email how to suppress those?

  Thanks

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  August 30, 2019 at 7:10 pm

  #3675836

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Jeff Moden

  SSC Guru

  Points: 1004439

  More actions

  August 31, 2019 at 3:23 am

  #3675969

  You should ask Ola. 😉  He wrote it.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 31, 2019 at 1:41 pm

  #3676040

  Ola's scripts are AG-Aware so they should do nothing on a secondary for databases that are in an AG.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question