Query to reschedule the SI

Agenda

The below KBA helps in reschedule the SI's to any specific time, this query will help to reschedule the scheduled executions.

Usage

 When there's an unplanned maintenance activity  or patching or any application upgrades , when it is required to reschedule the executions

db.getCollection('execution.executions').

updateMany({status:"SCHD", "scheduledOn":<current_scheduledOn_value>,"_metadata.deleted":false},{"$set":{"scheduledOn":

<updated_scheduledOn_value>}})      

Please note, 

• scheduledOn value must be epoch. 

• update the scheduledOn value in the query to the time you have to reschedule the SIs.

Example query,

If you want to reschedule the July 20th SIs from 10 PM to 8 PM

db.getCollection('execution.executions').

updateMany({status:"SCHD", "scheduledOn":1689957000,"_metadata.deleted":false},{"$set":{"scheduledOn":1689949800}})

EX1,EX2,EX3 will be rescheduled to 8 PM from the below table.