Maintenance mode in USM- table information

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Understanding 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

 

Environment

UIM 8.x, 9.x 20.x

Resolution

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