How to Configure Cron Schedules for 2nd & 4th Saturday and Sunday Weekly Offs

1. Purpose

This KT explains the process shown in the provided screenshots for exporting PPM/Housekeeping schedule data, adding or updating the Cron Expression in Excel, importing the file back into the system, mapping the Excel headings to system fields, and updating the records.

2. Step-by-Step Procedure

Step 1 – Export the PPM / Housekeeping Schedule

Open the relevant PM/PPM area and use the export option. In the provided screenshot, the export dialog shows the ‘All PMs’ option and the ‘Download All PM’ button.

Step 2 – Prepare the Excel File

Open the downloaded Excel file. Remove columns that are not required for this update, keeping the identifiers and fields needed for the import. The source example keeps ‘uuid’ and ‘Name’ and adds a new column called ‘Cron’.

Step 3 – Add the below Cron Expression

0 8,9,10,11,12,13,14,15,16,17,18 1-7,15-21 * 6;0 8,9,10,11,12,13,14,15,16,17,18 * * 1-5

Step 4 – Import the Updated Excel File

Return to the import/update workflow and upload the same Excel file. Select ‘Update Existing’ rather than ‘Add New’, because the purpose is to update existing schedule records.

Step 5 – Match Excel Headings with System Fields

On the Update Existing screen, map each Excel heading to the corresponding system field. The screenshot shows the Excel headings ‘uuid’, ‘Name’ and ‘Cron’.

Step 6 – Update the Records

After all mappings are correct, click Update/Upload as shown in the import workflow. The system will apply the Cron Expression to the existing records identified by uuid.

7. Cron Expression Verification

Use the following online tool to check and understand Cron expressions:

Crontab Guru: https://crontab.guru/

Enter one Cron segment at a time. For a semicolon-separated value, verify each segment separately because Crontab Guru is designed around standard Cron expressions rather than an application-specific semicolon format.