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.

                                 

Execution Id

Status

scheduledOn

EX1

SCHD

20-July-2023 10:00:PM

EX2

SCHD

20-July-2023 10:00:PM

EX3

ACSC

15-July-2023 10:00:PM

EX4

RJCT

15-July-2023 10:00:PM

EX5

SCHD

20-July-2023 10:00:PM