Understanding 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, doing more than regular processes can. 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 automatically display 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 function discovers all the Primary and foreign keys using the formula 'Row Count of a table = Distinct count of a table column.'
- Discover Relationships Automatically: This job builds relationships automatically based on data mapping utilizing profiling statistics within the provided data source and schemas within a data source.
- Project Level Relationships Building: It constructs relationships for a specified project name consisting of tables.
Accessing 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 explains the details associated with each Advanced Job.
|
Field Name |
Description |
|
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. |
|
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 On |
It displays the timestamp on which the advanced job was last run. |
|
Authorized Roles |
It displays all the roles that are authorized to run a particular job. The admin can configure to add or remove roles 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 Advance Job’ button available on the top right corner of the screen. Users can also trigger multiple Advanced Jobs at the same time. 
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 help the users to build 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 at the same time. 