Setting up SQL Agent Jobs in Alwayson

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  December 2, 2016 at 10:14 am

  #337874

  Hello Experts,

  Was wondering for alwayson, we need to create login accounts in all the nodes of the Alwayson Group. Typically what happens for SQL Jobs? Do we also need to create them in all the nodes?

  Secondly, does application are recommended to connect to Alwayson either by listener or by the Cluster Virtual name or by the stand alone nodes?

  Please suggest.

  Thanks.

  Thanks.

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  December 2, 2016 at 10:36 am

  #1915792

  Please don't cross post. It just fragments replies and makes it harder.

  The original thread can be found here. http://www.sqlservercentral.com/Forums/Topic1839767-3411-1.aspx

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/