Create and Manage Jobs

When you execute a data load, data flow or workflow Oracle Data Transforms creates a job to complete the process in the background.

A job is made up of multiple steps that corresponds to an execution task.

The Jobs page by default, lists the execution job sessions that are running and completed for the present day as Date parameter is set to Today by default. You can click on any of the instance IDs from the list to see its details.

To work with jobs in Data Transforms, you can do the following:

Create a Job from the Home page

To create a new job,

  • On the Home page, click Jobs on the left pane to access the Jobs page.
  • Click Create Job.

    The Create Job page slides-in.

  • From the Resource Type drop-down, select the type of resource for which you wish to create a new job. It can be - Data Flow, Workflow or Schema.
  • All the resources associated with the selected Resource Type get listed in the Resource field. From the Resource drop-down, select the required resource for which you wish to create a new job.
  • Click Create.

A new job is created and is added to the existing list of jobs in the Jobs page.

For each session, you can see the Job Session ID, Name, Status, Start Time and End Time for each of the jobs that are executed.

Create a Job from the Projects page

To view the job sessions pertaining to a specific project:

  • Click the Project tile displayed in the Projects page.

    Project Details page appears.

  • In the left pane, click Jobs.

    Jobs page appears. It displays all the jobs and their details pertaining to the selected project.

    Note

    This page is project specific and displays only the jobs pertaining to the selected project.
  • To create a new job, click Create Job.
  • Enter all the required details and click Create.

    A new job is created and is added to the existing list of jobs for the project.

View and Delete a Job

Click the Actions menu (Actions icon) to View Details of the jobs, Delete and Rerun the jobs, if required. If any of the steps failed, you can click on them to see the error details.

To delete a job, select the check box of the respective job session and click Delete. Upon confirmation the selected job gets deleted.

Configure Purge Interval for Jobs

You can configure the interval to purge older jobs to reduce the load on the sessions table. The default time interval is 30 days, which means that all jobs that are older than 30 days will be purged periodically. Note that only an ADMIN user (odiadmin) can configure the purge interval.

To configure the purge interval for jobs, click the gear icon (Gear icon) on the Jobs page. In the Configurations dialog box, set the required value in the Delete jobs before (days) field and click Save.

Search for a Job

You can also search for the required job session to know its details based on filters such as:

  • Name - Name of the Job
  • Status - Select the required session status from the list - All, Done, Error, Queued, Running, Waiting and Warning.
  • Date - Select the date in which the required job session was executed - All, Today, Yesterday, Last Week, Last Month and Custom Range, which allows you to select specific From and To dates.