DX Unified Infrastructure Management

 View Only
  • 1.  Maintenance mode in USM- table information

    Posted May 21, 2020 06:05 AM
    Hi All,

    Just want to understand the columns of  maintenance mode table -maintenance _schedule

    Here this schedule is created to run everyday from 1.56 AM to 4.11 AM , so If i look into the table start time and duration n all looks fine.

    Recurrence pattern is set as "1"

    Recurrence period is also set as "1" 

    Recurrence days of the weeks is set as "NULL"

    What is it mean? I also see for few schedules the recurrence pattern value as 2 , 3 , etc...just want to understand how the values are defined here. 



    SCHEDULE_ID SCHEDULE_NAME START_TIME DURATION DESCRIPTION ACCOUNT_ID RECURRENCE_PATTERN RECURRENCE_PERIOD RECURRENCE_DAYS_OF_THE_WEEK RECURRENCE_DAY_OF_THE_MONTH RECURRENCE_INSTANCE RECURRENCE_END_TIME TIMEZONE
    2609 Microsoft Patch Update DHFL PRAMERICA LIFE INSURANCE COMPANY LTD - July Month 2018 || Ticket No: IT# 22-07-2018 01:56 135 Microsoft Patch Update DHFL PRAMERICA LIFE INSURANCE COMPANY LTD - July Month 2018 || Ticket No: IT#0000735199 4 1 1 NULL 0 0 NULL Asia/Calcutta


    Regards,
    Usha


  • 2.  RE: Maintenance mode in USM- table information
    Best Answer

    Broadcom Employee
    Posted May 21, 2020 09:31 AM
    I found the below information.

    RECURRENCE_PATTERN

    INTEGER

    Stores type of recurrence.

    Possible values (1,2,3,4,5) corresponding to (once only, daily, weekly, monthly, yearly)

    RECURRENCE_PERIOD

    INTEGER

    Reoccur after how many days/weeks/months

     

    Upper limit as 365 for days, 52 for weeks ,12 for months .

    RECURRENCE_DAYS_OF_THE_WEEK

    VARCHAR(255)

    Stores the day of the week.

     

    Possible values (1 to 7) corresponding to (Sunday – Saturday)

    * applicable to monthly & weekly schedules only

    RECURRENCE_DAY_OF_THE_MONTH

    INTEGER

    Stores which day of the month.

     

    Eg : -

    If the schedule is to be executed every 3rd day of the month. Its stores 3.

    Possible values (1 to 31)

     

    * applicable to monthly only

    RECURRENCE_INSTANCE

    INTEGER

    Stores which day of the month.

     

    Eg :- 3rd Tuesday of a month.

    Stores 3 here.

    Possible values (1,2,3,4,5) corresponding to (first, second, third, fourth, last)

     

    * applicable to monthly only

    RECURRENCE_END_TIME

     TIMESTAMP

    Ending day and time for a schedule

     infinite: NULL




    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------