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.
