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

    Custom groups.

    shaun_9999

      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

       

      Regards

      A man that knows nothing about SQL

       

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