Search the Community
Showing results for tags 'maintenance window'.
Found 2 results
The maintenancemode table has been replaced with a view which emulates the data the maintenancemode table used to contain by building it from the new maintenancemodequeue table. However CW screwed up the SQL because instead of using a stock MySQL function they tried to calculate some time / datetime values themselves. With long-lasting maintenance modes this can overflow the maximum value for a time datatype which causes the SQL to throw warnings and produce incorrect output. Here's a fix - submitted to CW as Ticket#13557433 on 2020-070-02 You'll likely need to replace this after every upgrade / patch until CW get around to fixing the code in their releases. I wouldn't hold your breath - last time it took two years for them to replace their broken SQL with the fix I gave them. Note - I have not confirmed that the output of this table matches what would have existed in the old maintenancemode table under all conditions. Instead I have focused on just fixing the calculations CW used. To use either directly run / import the direct-import file below, or open the view in your SQL editor and paste the view-content file into the view and click save. maintenancemode-fixed-2020-07-02-direct-import.sql maintenancemode-fixed-2020-07-02-view-content.sql
So we need to set a custom maintenance window for one of the locations for one of our clients. We need a window from 5pm to 12am every first and third Sunday. I have never written a script for Automate before so I am not even sure where to start. Has anyone done anything like this before? Is this even possible? Thanks!