Scheduled jobs installed with Workplace Calendar Synchronization
Summarize
Summary of Scheduled jobs installed with Workplace Calendar Synchronization
The Workplace Calendar Synchronization in ServiceNow includes several scheduled jobs designed to automate and streamline calendar and reservation synchronization processes. These jobs handle tasks such as cleaning up stale reservations, syncing reservation data with external calendars, and managing attendee information across different calendar providers like Microsoft Exchange Online and Google Calendar.
Show less
Key Features
- Automatic Cleanup: Jobs run every 5 hours to clear reservations stuck in awaiting confirmation due to rejections from Outlook or Microsoft Exchange On-Premises, ensuring data consistency and avoiding clutter.
- Reservation Synchronization: Frequent jobs (every 1 minute) create and update reservations from Microsoft Exchange Online events, maintaining up-to-date reservation records in ServiceNow.
- Calendar Export: An inactive-by-default job that can export reservations to external calendars, creating events and linking them with reservation records to enable two-way synchronization.
- Subscription and Error Monitoring: A daily job notifies administrators about subscription renewal failures related to active reservable sync configurations, enabling timely issue resolution.
- Multi-Reservation Processing: Every 15 minutes, reservations incorrectly created as singles from external sources are grouped correctly into multi-reservations.
- Reprocessing Failed Syncs: Optional jobs to reprocess failed synchronization events and to synchronize calendar items specifically for Microsoft Exchange Online On-Premises and Google Calendar providers.
- Attendee Synchronization: Jobs running every 4 minutes update attendee information from calendar events to ServiceNow reservations for both Google Calendar and Microsoft Exchange Server integrations.
- Webhook Event Management: For Microsoft Exchange Online, a job runs every minute to queue webhook notifications, preventing race conditions and ensuring reliable event processing.
- Weekly Configuration Check: A weekly scan validates calendar sync configurations post-setup to maintain synchronization health.
Key Outcomes
- Maintains accurate and timely synchronization between ServiceNow reservations and external calendar events.
- Reduces manual intervention by automatically cleaning up failed or stuck reservations and reprocessing failed sync events.
- Enhances reliability and performance of calendar integrations through dedicated jobs managing webhook events and subscription status.
- Supports synchronization across multiple calendar providers, ensuring attendee data and reservation details remain consistent.
- Provides administrators with alerts and configuration validations to proactively manage synchronization health and troubleshoot issues.
The Workplace Calendar Synchronization includes scheduled jobs to process a few synchronizations seamlessly.
| Scheduled job | Scope | Active | Time | Description |
|---|---|---|---|---|
| Clean-up Awaiting/Rejected Reservations | Workplace Calendar Synchronization | True | Repeats every 5 hours | This scheduled job clears the reservations that have been stuck in awaiting confirmation for more than 5 hours (due to rejection from outlook) |
| Create and Update Reservations from Events | Workplace Calendar Synchronization | True | Repeats every 1 minute | This scheduled job inserts/updates reservations from > table. |
| Export reservations to calendar | Workplace Calendar Synchronization | False | Repeats every 15 minutes | This scheduled job is inactive by default. The scheduled job syncs existing Workplace Reservation Management reservations with the calendar.
|
| Subscription renewal failure notification job | Workplace Calendar Synchronization | True | Daily | This scheduled job checks for failed subscriptions that are linked to active reservable sync configuration records and notifies users with the rsvsync_admin role. |
| WSDRS Multi reservation processor | Workplace Calendar Synchronization | True | Repeats every 15 minutes | This scheduled job turns reservations that are incorrectly created as single from an external source into correctly grouped multi children |
| WSDRS Reprocess Events | Workplace Calendar Synchronization | False | Repeats every 15 minutes | This scheduled job reprocesses the synchronization calls for WSD events that failed to process. |
| WSDRS Sync Calendar items | Workplace Calendar Synchronization | False | Repeats every 2 minutes | This scheduled job runs only for Microsoft Exchange Online On-Premises and Google Calendar provider. This job is not applicable to Microsoft Exchange Online. This scheduled job synchronizes all the events of a calendar for all the locations that have active reservable sync configurations. |
| Update attendees of Workplace Reservation (Google) | Workplace Calendar Synchronization | True | Repeats every 4 minutes | This scheduled job is installed when the Google Calendar Spoke is installed. This job synchronizes attendees, who were synced from Calendar events and stored in the calendar items, to the Reservations table. |
| Sync attendees for onPrem | Workplace Calendar Synchronization | True | Repeats every 4 minutes | This scheduled job is installed when Microsoft Exchange Server Spoke is installed. This job synchronized attendee, who were synced from Calendar events and stored in calendar items, to the Reservations table. |
| Clean-up Awaiting/Rejected Reservations (OnPrem) | Workplace Calendar Synchronization | True | Repeats every 5 hours | This scheduled job clears the reservations that have been stuck in Awaiting confirmation for more than 5 hours (due to rejection from Microsoft Exchange Online On-Premises). |
| Queue Webhook Events | Microsoft Exchange Online Spoke | True | Repeats every 1 minute | As Microsoft Exchange Online sends many notifications for each change, to avoid a race condition, the notifications are captured in the Webhook Notification [sn_ex_online_spke_webhook_notification] table and queued to the Callback Queue [sn_ex_online_spke_callback_queue] table through this scheduled job. |
| Weekly schedule scan | Workplace Calendar Synchronization | True | Once a week | This schedule job is a scan performed after the configuration. It is a suite for checking calendar sync configuration. |