# 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.
{% hint style="info" %}
All Advanced Jobs displays a list of advanced jobs within the application. Migration Advanced Jobs specifically lists migration-related jobs based on the selected "from" and "to" versions.
{% endhint %}
### List View
The table below provides details about 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 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.
