Change management

^{Introduced via support-team-meta#4077}

Schedule changes

Note This only applies for the non-shadow schedules. For changing shadow schedules, please see shadow schedule changes.

The process for this can be broken down into 3 sections:

1. Notify DRIs about the upcoming implementation
2. Implement the changes
3. Rotate the spreadsheet

Notify DRIs about the upcoming implementation

On the first Monday of the second month of a given quarter, we notify the DRIs about the upcoming implementation. This is done automatically via Slack workflows, but for reference, the timing and messaging used is as follows:

Implement the changes

During the first week of the final month of the quarter, you need to setup all the schedules we use to align with the requested changes in the Support Pagerduty Worksheet.

To do this, we utilize the Schedule Implementer project.

To utilize this, navigate to the location of the Schedule Implementer repo on your local computer.

You will want to run the bundle command to download the needed gem (and it’s dependencies).

After doing so, you should verify you have the needed environment variables set in your local environment (see the project’s README for more details).

With those in place, setup the config.json file within the data folder by doing the following:

echo $SERVICE_CREDS > data/config.json

After that has been done, you will run the script itself using:

./bin/add_to_schedule

The output should show you if each override for each group within each schedule was created correctly. If you see a status of 201, it was successful. If you see anything else, it did not succeed (and manual intervention will be required).

After you have run that script, go into Pagerduty and check the corresponding schedule for accuracy.

Rotate the spreadsheet

After you have implemented the changes into Pagerduty, the final thing you need to do is rotate the spreadsheet. How you do this is really up to you, but the general recommended way is to do the following:

• Select the following quarter’s entries on the spreadsheet and hit the DEL key on your keyboard twice (this ensures it fully deletes everything)
• Copy all the remaining entries and paste them from the 2nd line of the file (the one right after the headers).
• Navigate to the bottom of what you just copied, select the remaining entries, and hit the DEL key on your keyboard twice (this ensures it fully deletes everything)
• Select the last 5 rows on the spreadsheet, click the dot at the bottom-right of your selection (holding the mouse button down), and drag it down however many rows you need to add (if you are unsure, go down about 93 rows, as that should cover all the days). Doing this will automatically fill out the needed information for you.

Shadow schedule changes

These are now fully automated via the Support Super form. As such, you should never need to make modifications to them.

Escalation policy changes

This can be a very destructive action. Due to the complexity involved, we do not have a fully documented process for this at this time.

As such, please only have @jcolyer or @dtragjasi work these at this time.

Service changes

This can be a very destructive action. Due to the complexity involved, we do not have a fully documented process for this at this time.

As such, please only have @jcolyer or @dtragjasi work these at this time.

Spreadsheet setup

The Support Pagerduty Worksheet is setup in a very specific way to facilitate planning for the next quarter’s changes.

Dropdowns reflect the entire pool of possible people for that dropdown

Each dropdown’s content is determined based on the pool of possible people that could be used. This is done via a range on the People sheet.

Never make edits directly to the dropdown values. If you need to add or remove someone from the possible options, please do so on the People sheet. This is usually done by provisioners during onboarding, offboarding, and team member transfers.

We have many protections in place

We have several protections in place on the sheet to prevent editing cells that are not meant to be edited:

View page source - Edit this page - please contribute.