Knowledge Center

Navigate topics

Maintanance Schedule

Scheduling options UI

Scheduling Options for Maintenance Rules

1.  Familiar Interface:

The scheduling options are modeled after the MSSQL Job Scheduler to provide a familiar look and feel for seamless integration.

2. Flexible Scheduling:

  1. You can attach one or more schedules to any maintenance rule, enabling precise control over execution. You can do that by pressing the
  2. For Backup Rules, it is recommended to apply distinct schedules to each rule to optimize performance and resource utilization.

3.  Position in Rule Execution:

The scheduling step is always positioned as the penultimate step in any maintenance rule workflow, ensuring all preceding configurations are processed before scheduling.

4. Edition-Specific Scheduling Types:

Different scheduling types are available for Express Edition Templates and Express Custom Rules, accommodating the unique requirements of these environments.

Schedule Management Features

  1. Open Schedule Configuration Dialog
    Enables the creation of a new schedule for the selected maintenance rule by opening the configuration dialog.
  2. View Configured Schedule Details
    1. Displays the specifics of the existing schedule.
    2. Includes Edit and Delete options for modifying or removing the schedule as required.

One time schedule

One-Time Schedule Configuration

  1. Schedule Name
    Assign a descriptive name to the schedule for easy identification.
  2. Select One-Time Schedule Type
    Choose the one-time schedule option to execute the maintenance rule at a specific time.
  3. Set Starting Time
    Specify the exact time for the one-time schedule to initiate.

Daily schedule

Daily Schedule Configuration

  1. Daily Time Schedule Type
    Specifies the type of schedule to be executed on a daily basis, defining both the timing and frequency of maintenance rule execution.
  2. Daily Frequency
    Determines the interval at which the maintenance rule will run during the day.
  3. Daily Frequency Options:
    1. Single Occurrence:
      Executes the maintenance rule at a specific time during the day, such as 9:00 AM.
    2. Recurring Occurrence:
      Executes the maintenance rule multiple times within the day, e.g., every 2 hours, starting at 10:00 AM and ending at 3:00 PM.
  4. Activation and Deactivation Times:
    Start At: Specifies when the schedule becomes active.
    End At: Specifies when the schedule will automatically deactivate.

Weekly Schedule

Weekly Schedule Configuration

  1. Weekly Schedule Configuration
    Defines a schedule to execute maintenance rules on specific days of the week.
  2. Weekly Recurrence Interval
    Determines the number of weeks between each execution (e.g., every week or every two weeks).
  3. Select Applicable Days
    Choose the days of the week when the schedule will be active.
  4. Daily Frequency Options:
    1. Specific Time Execution:
      Executes the maintenance rule at a designated time, such as 9:00 AM.
    2. Recurring Intervals:
      Executes the maintenance rule repeatedly within a day, e.g., every 2 hours from 10:00 AM to 3:00 PM.
  5. Activation and Deactivation Times:

    1. Start Time: Specifies when the schedule will activate.
    2. End Time: Specifies when the schedule will automatically deactivate.

Monthly Schedule

Monthly Schedule Configuration

  1. Monthly Schedule Type
    Configures a schedule to execute maintenance rules on a monthly basis.
  2. Monthly Occurrence Options:

    1. X Specific Day of the Month:
      Executes the rule on a specific day of the month, such as the 3rd day of every second month.
    2. X Complex Occurrence:
      Executes the rule on a specific day and week combination, such as the Second Friday of every third month.
  3. Daily Frequency Options:
    1. Single Time Execution:
      Executes the rule at a specific time during the day, e.g., 9:00 AM.
    2. Recurring Intervals:
      Executes the rule multiple times within a day, e.g., every 2 hours starting at 10:00 AM and ending at 3:00 PM.
  4. Activation and Deactivation Times:
    1. Start At: Specifies when the scheduler will activate.
    2. End At: Specifies when the scheduler will automatically deactivate.

Express Scheduling options UI

One time schedule

One-Time Schedule Configuration

  1.  Schedule Name
    Assign a descriptive name to the schedule for easy identification.
  2. Select One-Time Schedule Type
    Choose the one-time schedule option to execute the maintenance rule at a specific time.
  3. Set Starting Time
    Specify the exact time for the one-time schedule to initiate.

Daily Schedule

Daily Schedule Configuration

  1. Schedule Name
    Assign a descriptive name to the schedule for easy identification.
  2. Daily Time Schedule Type
    Specifies the type of schedule to be executed on a daily basis, defining both the timing and frequency of maintenance rule execution.
  3. Daily Frequency
    Determines the interval at which the maintenance rule will run during the day.
  4. Daily Frequency Occurrence::
    Executes the maintenance rule multiple times within the day, e.g., every 10 minutes.
  5. Activation and Deactivation Times:
    1. Start At: Specifies when the schedule becomes active.
    2. End At: Specifies when the schedule will automatically deactivate.

Weekly Schedule

Weekly Schedule Configuration

  1. Schedule Name
    Assign a descriptive name to the schedule for easy identification.
  2. Weekly Time Schedule Type
    Specifies the type of schedule to be executed on a weekly basis, defining both the timing and frequency of maintenance rule execution.
  3. Weekly Frequency
    Determines the interval at which the maintenance rule will run weekly.
  4. Days of the week
    Determines which days of the week the schedule will run.
  5. Daily Frequency Occurrence:
    Executes the maintenance rule multiple times within the day, e.g., every 10 minutes.
  6. Activation and Deactivation Times:
    1. Start At: Specifies when the schedule becomes active.
    2. End At: Specifies when the schedule will automatically deactivate.

Monthly Schedule

Monthly Schedule Configuration

    1. Schedule Name
      Assign a descriptive name to the schedule for easy identification.
    2. Monthly Time Schedule Type
      Specifies the type of schedule to be executed on a weekly basis, defining both the timing and frequency of maintenance rule execution.
    3. Monthly Frequency
      Determines in which months the schedule will be active.
    4. Days of the month
      Determines which days of the month the schedule will run.
    5. Days of the month occurrence
      Determines day G week frequency. For example, runs on the 1’st and 2’nd week of the month on Sunday.
    6. Daily Frequency Occurrence
      Executes the maintenance rule multiple times within the day, e.g., every 10 minutes.
    7. Activation and Deactivation Times:
      1. Start At: Specifies when the schedule becomes active.
      2. End At: Specifies when the schedule will automatically deactivate.

Request a demo

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Contact Sales

Fill out your details. 

We’ll get back to you soon.

Request a Proposal.

Fill out your details. 

We’ll get back to you soon.

Contact us

Fill out your details. 

We’ll get back to you soon.

Need professional DBA services?

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Need professional BI services?

Fill out your details. 

We’ll get back to you soon.

Get help from Experda

Fill out your details. 

We’ll get back to you soon.

Request a demo

Fill out your details. 

We’ll get back to you soon.

This website uses cookies to remember you and improve your experience. To find out more see our Privacy Policy.