Workplace planned maintenance scheduled job
Summarize
Summary of Workplace planned maintenance scheduled job
TheWorkplace Planned Maintenance Nightly Runscheduled job automates the creation of maintenance cases in ServiceNow based on configured schedules. It supports both duration-based and meter-based maintenance schedules and can pre-create cases up to two days in advance, considering time zone differences between the system and workplace agents. This job ensures timely generation of maintenance cases to streamline workplace asset and location management.
Show less
Key Features
- Duration-based case creation: The job fetches active maintenance plans with upcoming run times, filters them based on a 48-hour threshold, and creates cases only if a template is associated to the maintenance schedule.
- Meter-based case creation: The job compares meter values from assets against scheduled thresholds and creates cases when the asset’s meter exceeds the Next run value, again requiring associated templates.
- Pre-creation of cases: For schedules shorter than a day (e.g., six-hour intervals), the job creates multiple cases per day per asset or location, enabling more granular maintenance tracking.
- Template association: Maintenance cases are created only if templates from the Workplace Maintenance Service Configuration table are linked to the schedule, supporting multiple templates per plan.
- Lead time configuration: Duration-based schedules can specify a minimum lead time, allowing cases to be generated ahead of the scheduled maintenance date for planning purposes.
Practical Application for ServiceNow Customers
By leveraging this scheduled job, customers can automate the generation of maintenance work cases accurately and in a timely manner, improving operational efficiency and maintenance preparedness. The ability to pre-create cases based on duration or meter readings ensures that maintenance teams have clear, actionable tasks aligned with asset condition and schedule requirements.
To implement this, ensure your maintenance schedules are configured with appropriate templates linked via the Workplace Maintenance Service Configuration table. Adjust lead times as needed to control case creation timing relative to planned maintenance activities. Monitor the scheduled job to confirm case creation aligns with your maintenance strategy.
The scheduled Job Workplace Planned Maintenance Nightly Run runs at the configured time and creates maintenance cases. It also pre-creates maintenance cases when the scheduled duration is less than a day.
The scheduled job can pre-create cases for day and up to two days ahead of the scheduled time. This is based on the time difference between the system time zone where the job is running, and the workplace agent time zone working on the cases.
- Creates duration-based cases.
- Creates meter-based cases.
The scheduled job can also pre-create maintenance cases when the schedule configured is less than a day. The duration is based on your system time zone settings. For example, if you have a maintenance schedule of six hours, it creates the following number of maintenance cases:
- For a six-hour schedule, four maintenance cases are created for each maintenance asset or location in a day.
- For a six-hour schedule, eight maintenance cases are created for two maintenance assets or locations in a day (four cases for each).
Figure 1. Workplace Maintenance cases - For a six-hour schedule, 12 maintenance cases are created for three maintenance assets or locations (four cases for each).
Duration-based cases
- Fetches all active plan records having the Next run time duration.
- Filters out plan records where the Next run time is 48 hours or less than a day.
Figure 2. Schedule job Next run time - Checks for an entry in the Workplace Maintenance Service Configuration (sn_wsd_maintenance_service_config) table.
- Gets all records from the Workplace Maintenance Service Configuration table.
- For each record in the Workplace Maintenance Service Configuration table, the schedule for the current plan record must have a template associated to it.
- If there’s a template, the scheduled job creates a maintenance case and updates the Next run time in the Workplace Maintenance Service Configuration table for a plan record.
- If there’s no template associated to a plan record, the scheduled job fetches the next plan record in a queue.
Meter-based cases
- The scheduled job fetches all active plan records having a Next run value.
- For each plan record, the Next run value depends on the Field name value. The Field value is available when you’re creating a meter-based schedule.
For more information, see in Create or copy a maintenance schedule.
- The scheduled job retrieves the value of the Field name from the Asset (sn_ent_asset) table and compares it with the Next run value for a plan record.
- The schedule job checks if the Next run Value is less than the actual value in the Asset table and proceeds further.
- if the Next run value is more, it fetches the next plan record in a queue.
- The maintenance schedule for a current plan record must have an entry in the Workplace Maintenance Service Configuration (sn_wsd_maintenance_service_config) table.
- Gets all the records from the Workplace Maintenance Service Configuration table for that schedule in a Plan record.
- For each record in the Workplace Maintenance Service Configuration table, the schedule for the current plan record must have a template associated to it.
- If there’s a template associated to a maintenance schedule, the schedule job creates a workplace maintenance case and updates the Next run value for a plan record.
- If there’s no template associated to a maintenance schedule, the scheduled job picks up the next plan record in a queue.