# General Advanced Jobs

| Name                                              | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| ------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Re-Encrypt DB Sensitive Data                      | This job re-encrypts sensitive database information using updated encryption keys to ensure data security and compliance.                                                                                                                                                                                                                                                                                                                                                                                                              |
| Normalize Jobflow                                 | This job reorganizes the X and Y coordinates in job flows, eliminating gaps and aligning the structure.                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Restore archived data                             | <p>This Job allows users to retrieve historical data related to tags and terms that were previously archived and are no longer visible in the application. It ensures continuous access to past operations for auditing and compliance purposes. Users can restore the archived data into the original or a temporary table, making it easier to track changes, maintain data governance, and meet regulatory requirements even after data has been archived.</p><p><br></p><p>Note: This job is run based on the client's request</p> |
| Reset TimeZones For Schedule                      | This job updates the time zones for schedules that do not have a valid time zone associated with them. It will update the time zone to match the server's time zone.                                                                                                                                                                                                                                                                                                                                                                   |
| Remove Base URL from Image Paths                  | This job removes the base URL prefix from image paths stored in descriptions, enabling proper rendering of images after version migration. It is beneficial when migrating instances where the image links contain hardcoded URLs from the previous environment.                                                                                                                                                                                                                                                                       |
| MetaData Change Report Sync Service               | This job imports all the data from the XLSX sheet and inserts it into the database, removing any existing records.                                                                                                                                                                                                                                                                                                                                                                                                                     |
| DataLake Analysis Second Level                    | This job is the second-level analysis of the data lake. It requires two attributes attr1: datalake connectioninfoid, attr2: folderPath                                                                                                                                                                                                                                                                                                                                                                                                 |
| Delete Inactive Users for SSO                     | This job deletes inactive users in OvalEdge by verifying their status in Azure AD.                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Cache scopes associated to a Business Application | This advanced job retrieves the scopes associated with the Business Application and caches them in OvalEdge.                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Caching of Business Applications from UPC         | This job will sync business applications from UPC to OE cdr\_products. These products will be consumed to raise the Service Requests.                                                                                                                                                                                                                                                                                                                                                                                                  |

***

Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA.