Greetings,
My company is writing a wrapper stored procedure which we will call on a centralized monitoring SQL Server instance to put SQL Server instances in maintenance mode. As part of this routine we would like to know the values for the MaintenanceModeType column in MonitoredSQLServers table. From what I can gather a 0 means no maintenance while 1 means manual maintenance. I am curious all the values are that could be set.
Thank you very much.
Shahryar