Maintenance Mode Scheduling revealed!
Which feature was the most expected in Operations Manager? Maintenance Mode Scheduling. Which feature was given for us in SCOM Technical Preview 2? Maintenance Mode Scheduling. I thought WOW, this must something the whole admin population must be thrilling about. And as I saw on twitter – it was. So let’s see what’s all the fuss about.
After installation of Technical Preview 2 from VHD file available from my previous post I was given a nice little pop-up as always.
After launching, nothing really has changed in the main monitoring view. So my first click was an Administration panel in SCOM wunderbar (bottom left pane). So except Operational Insights (which will be described in later posts) my sight was already there – Maintenance Schedules entry.
Clicking it revealed a new pane for Maintenance Mode Scheduling.
Nothing else to do but start playing with it – thought. So let’s try doing the first schedule. Click on the right pane to Create Maintenance Schedule.
Because I have only one server (the MS itself) I had to choose something, that will not affect the total health of it. After thinking for a while I’ve chosen Operating System class and all objects underneath.
Accepting this moved us to second pane – scheduling. This is the best part as you can schedule a maintenance once, daily, weekly, monthly, set start and end date, length and expiry date of the schedule!
Lastly, the details of maintenance. So let’s give it a name and reason then…
After quick run through the wizard, I was given a proper entry in the Maintenance Schedules pane.
…and after few minutes…
… both MM was enabled and the object was properly put in MM too.
CONCLUSION: IT WORKS!
It’s all there in the database. If you like to play with it, you can drill down into OperationsManager database and what will be found is:
- VIEW: dbo.MaintenanceModeView
- TABLES: dbo.MaintenanceMode, dbo.MaintenanceModeSchedule and dbo.MaintenanceModeHistory
Querying those give you good insight on what’s going on and what happened in the past:
QUERYING SCHEDULE TABLES
QUERYING HISTORY TABLES
QUERYING MAIN TABLE
As you see, there’s a ScheduleId column (which is not added in the view) which goes exactly to MaintenanceModeSchedule table. You can link both tables to get more info in one result set.
Whole work (adding, deleting, launching, editing etc.) is being done by stored procedures, which are added to handle schedules.
Happy scheduling 🙂