Advanced Jobs
Advanced Jobs are like mini-applications made for specific tasks. They allow OE_ADMIN users to manage a feature's behavior using advanced algorithms, exceeding the capabilities of regular processes. Designed for complex needs, advanced jobs tackle unique and challenging problems.
For instance, Primary Key and Foreign Key relationships on tables from remote data sources are automatically displayed when crawling. Advanced jobs, each with a distinct purpose, have been developed:
Get Relationships with Column Names: This job constructs relationships by matching column names.
Discover Primary and Foreign Key Recommendations Auto: This feature is used to identify all primary and foreign keys by applying the formula 'Row Count of a table = Distinct count of a table column.'
Discover Relationships Automatically: This job builds relationships automatically by mapping data, utilizing profiling statistics within the provided data source and schemas.
Project Level Relationships Building: It constructs relationships for a specified project name, consisting of tables.
Access Advanced Jobs
Administrators and authorized users/roles can access the Advanced Jobs by navigating to the Administration module from the left panel menu. The List View displays the list of advanced jobs.
List View
The table below provides details about each Advanced Job.
Id
It displays the unique ID for each Advanced Job.
Name
It displays the name of the Advanced Job.
Type
It displays the type of the Advanced Job, which can also be considered a key.
Executions
It displays the number of times the specific job has been executed since its creation.
Schedules
It displays the number of schedules associated with each job.
Job Workflows
It displays a numeric identifier for each job’s workflow.
Class
It displays the Java class of the Advanced Job.
Help
It helps users understand the purpose of Advanced Jobs and the attributes needed to run it.
Attribute1
To input the attributes required to execute the advanced job.
Attribute2
To input the attributes required to execute the advanced job.
Attribute3
To input the attributes required to execute the advanced job.
Attribute4
To input the attributes required to execute the advanced job.
Attribute5
To input the attributes required to execute the advanced job.
Job Status
It displays the status of the Advanced Job, with states including:
RUNNING: Jobs are being processed in the submitted order.
WAITING: A submitted job is in the queue, awaiting execution.
SUCCESS: The invoked job has been completed successfully.
PARTIAL SUCCESS: The submitted job has been executed partially, and the entire job could not be completed.
ERROR: The job has failed; users can check the error message in the logs.
INIT: A job has been initiated.
KILLED: The task is aborted, and the execution of the job is stopped.
Last Run Date
It displays the Date and timestamp on which the advanced job was last run.
Last Run By
It displays the user who last executed the job.
Authorized Roles
It displays all the roles that are authorized to run a particular job. The admin can configure roles to be added or removed using the edit icon provided in the corresponding fields.
Run Advanced Jobs
OE_ADMIN or Authorized Roles can execute an Advanced Job by selecting the checkbox against the corresponding advanced job and then clicking on the ‘Run Advanced Job’ button available in the top right corner of the screen. Users can also trigger multiple Advanced Jobs simultaneously.
Add Advanced Jobs
Administrators can register new Advanced Jobs by utilizing the 'New Advanced Job' option in the Nine Dots. Upon selecting the option, a pop-up window prompts administrators to provide the following details: Name, Type, Class, and Help.
Upon selecting the 'Add' button, the new Advanced Job will be registered for the new Advanced Job module. OvalEdge will then assist users in building the Advanced Job.
Delete Advanced Jobs
Authorized Roles can delete an Advanced Job by selecting the job and then clicking on the ‘Delete Advance Job’ option in the 9 Dots. They can also delete multiple Advanced Jobs simultaneously.
Migration Jobs
Migration Jobs displays a list of all migration jobs. Users can select the source (from version) and target (to version) to view the specific list of migration jobs associated with the selection.
Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA.
Last updated
Was this helpful?