Manage and Monitor the Job

Once the job is scheduled and created, you can mange the job and monitor each step you run for the job via the Report feature.

Manage the Job

On the Jobs page, click the Actions icon besides the Job you created and perform the following actions:


Description of manage-jobs.png follows
Description of the illustration manage-jobs.png

  • Delete: Select Delete to delete the job.
  • Run Job: Select Run Job to run the job. This will drop the table you loaded previously, re-run the data load, and create a new table with the same data, re-run the Table AI Assist recipe and run the procedure again.
  • Enable Job: Select Enable Job to enable the scheduling of the job you run.

    A confirmation message will be displayed that asks you if you want to run the job using the scheduler.

  • Disable Job: Select Disable Job to disable the scheduling of the job you run.

Report Jobs

After creating a job, you can monitor its status and execution history using the Report feature.

Select Report besides each step to view details about it's execution status.

You can view the following parameters with their values on the Report table:

Table 19-1 Report Parameters and their Descriptions

Report Parameters Description
LOG_DATE

This field refers to the date and time when the specific job was logged in the system.

It is stored in ISO-8601 format: 
YYYY-MM-DDTHH:MM:SSZ
ACTION
This field refers to specific actions or states related to job execution. Here are it's values:
  • RUN JOB: It refers to running a job immediately, regardless of its predefined schedule.
  • START JOB: It refers to enabling a job so that it can run according to its schedule. By default, jobs are created in a disabled state and must be enabled using the Enable Job icon.

    Once enabled, the Scheduler will automatically start the job at its next scheduled time or when triggered by an event.

  • FINISHED JOB: It refers to the state of a job after it has completed execution.
STEP TYPE This displays the step you have added in the Job feature. It can be Data Load, Smart Table or a Procedure.
STEP NUMBER This field displays the step number.
ROWS LOADED This field refers to the number of data rows successfully inserted into a table or processed during the execution of a job.
ROWS REJECTED This field displays the data records that were not successfully loaded or processed during a job execution due to various reasons such as data errors, constraint violations, SQL errors and insert or update failures.
ERROR MESSAGE This field provides detailed information about issues encountered during job execution. These messages are crucial for troubleshooting and resolving problems that may have caused a job to fail or complete with warnings.
DETAILS This field displays comprehensive overview of each job's execution.