2 Replies Latest reply on Aug 3, 2016 9:05 AM by ken_cohen

    Custom groups.


      Good morning


      I was thinking about SQL clustered servers again and noticed that as there are SQL
      jobs that a moving from one server to server when there is an issue, I thought it would be a good
      idea to somehow put these in a group.
      Though I am not entirely sure how to do this.  This is why I have come to the community for
      a little advice.


      I wanted to do the following:


      *this is an SQL cluster.  Please be imaginative.

      SQL1 - up

      SQL2 - down
      SQL3 - down

      SQL4 - down

      SQLX – down.


      I was thinking that we could monitor the cluster based on the application.  But I am unsure at the moment how to achievethis.  The question I have is what
      happens when another SQL starts to run jobs? Will I never receive notification that the server has failed? Or will I still get alerts based on an ‘notify me when a node goes down’


      While I am thinking of this, I guess I would have to use SQL to do this, or can this be done in the GUI



      A man that knows nothing about SQL


      - PS - I am doing a search to see if someone has had the same issue.