Create and Manage Jobs

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.

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

From the list of jobs displayed on the Jobs page, click the Actions menu (

) to:

View Details of the selected job.
Rerun the job.
Delete the job.

This page also includes the to refresh the displayed list and the icon that you can use to configure the purging of older jobs. See Configure Purge Interval for Jobs.

Click the job to see detailed information on the Job Details page such as:

Instance ID: The job ID.
Status: The status of the job - Done, Error, Queued, Running, Waiting, and Warning.
Design Object: The design object the job belongs to - data load, data flow, or workflow.
Start: The start date and time of job execution.
End: The end date and time of job execution.
Duration: The time taken to execute the job.
Row Count: Total number of rows processed during the job session.
Insert Count: Number of rows inserted during the job session.
Update Count: Number of rows updated during the job session.
Delete Count: Number of rows deleted during the job session.
Error Count: Number of rows that caused errors during the job session.

You can also use the following options:

Stop: Stops the job.
Rerun: Reruns the job.
Retry: Reruns the job from the step where it failed.
View Jobs: Displays the list of jobs.
Delete: Deletes the job.
Rerun Selected Tables: For data load jobs, allows you to rerun the job for selected tables. Note that you can use this feature for jobs where the main data load job has either completely successfully or has errors in any of the steps.

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 () 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. Note that to use the Queued and Waiting filter options in the drop-down you must enable the Show Queued/Waiting Jobs option.
Show Queued/Waiting Jobs – Enable this option to include the queued or waiting jobs in the list on the Jobs page. When this option is enabled, the Status drop-down includes the Queued and Waiting options that you can use to filter the list.
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.

13.1 Create and Manage Jobs