Here to Help

Jobs

Estimated reading: 8 minutes 245 views

Jobs are a sequence of tasks that can be chained together to enable the automation of business-critical tasks such as data acquisition, analysis, and reporting. You can execute a job instantly or schedule it for execution. You can view the status of an executing job or see its past execution history. You may also include the “Alert Task” to notify you of any failures or exceptions.

The section details on 

Create a Job

Steps to create a job

Consider we are creating a job named ‘Process Sales Data’ to fetch a few columns from a master datasource named “Sales” and uploading them to a new datasource, “Product Details“.

The tasks involved to create the job are,

  1. Clear Cache for the datasource “Sales”.
  2. Execute the query to fetch columns from the sales datasource.
  3. Upload data to the “Product Detail” datasource.

>> >>

Step 1:

  • Create a task to clean the cache for the master datasource “Sales” to add new data on every upload.

Step 2:

  • On the successful execution of the clean cache task, the query execution task will initiate, and the task will fetch the required columns from the master datasource.

Step 3:

  • On the success of fetching the columns, the final task of uploading the data to the new datasource will execute.
    • You will receive a success notification of the successful execution of the job.
    • You will receive a failure/ error notification if the job fails in any step. 

Prerequisites

  • You have the SQL query created on the master datasource to fetch the columns.
  • You have created a new datasource with the fetched columns and define the Measures and Dimensions for the data to be uploaded after the Job execution. 

Job is created based on the task. The progress of the job depends upon the success or failure of tasks involved in it. When the job executes , then “On success” task will execute otherwise “On failure” task will execute. This section covers how to create a job:

  1. Click on Automation Jobs  . All Jobs, those created by you or shared with you will be displayed.

  2. To create new Jobs, click New.

  1. To delete all the existing jobs for a specific date range click on Delete Instance 

To know more about tasks that are supported in Infoveave, see Tasks.

  1. On clicking New, you will be directed to the window where you can link the tasks to create the job.
  2. Issue a name for the job.
  3. Provide a description on the job type.
  4. Click on task type title to view all tasks available for job as a sequence of tasks.
    • Drag and drop main task first and select other tasks to execute for success and failure status of the main task.

Link from the success or failure of one task as the input to the following task accordingly.  

  1. Click on schedule  to schedule the job for execution.
    • The following section will detail on scheduling the job.
  1. Click on Save to save job configuration you created.
  1. Click Run Now  to start executing job. After clicking on run now, Infoveave send start execution notification. You will receive another notification whenever job execution finish.
  2. Click Run History to view overall as well as individual execution time and status of job with their tasks.
  3. Click Edit  to change the configuration of job.
  4. Click Share  to share job with other users.
  5. Click Delete  to delete the job from the existing list.

Schedule a Job

Schedule Job is an action to schedule the time at which a job automatically runs. Infoveave executes the job as per the scheduled time assigned by you. You can schedule job-based on day and time. Infoveave allows options such as:

  • Days of Week
  • Days of Months
  • Months

Example: If you create a task for sending a report for an automotive company based on weekly performance, you can schedule a job for it to run at selected time intervals.

    • If the task is “on success” then it can send the report to the manager of the company.
    • If the task is an “on failure” it will generate a failure notification as you can not generate the report.  

How to schedule your job

  1. Click Edit .
  2. Click on schedule  to schedule the job. Schedules dialog box will be displayed.
  3. Select the frequency at which you want the job to be executed. Infoveave offers three different ways:
  • Every: when you want to schedule  job after certain fixed time. Ex: every 2 hours.
    • If you have selected Hours, select value from range 1-23 hours.
    • Whereas if you have selected Minutes, select value from range 1-59 minute
  • On: when you want to schedule job only on fixed time in a day. Ex: morning 10 AM and evening 6 PM.
    • If you have selected Hours, select value from range 1-23 hours.
    • Whereas if you have selected Minutes, select value from range 1-59 minutes.
  • At: when you want to schedule job at certain specific time. Ex: At 6:30.
    • If you have selected At, select Hours and Minutes from  drop-down list.
  1. Select time zone from drop-down list.
  2. After deciding time of the scheduled job. Select days on which you want to execute the job. Infoveave offers three options such as Days of week, Days of month, Months. By default, Infoveave set to every day.
  3. Click on Add Schedule to set a schedule for job execution. Scheduled time will be displayed in a tabular form.
  4. If you want to delete scheduled time, Click .

View a Running Job

After creating and scheduling the job, you can check the status of the job. You can add the task in action to create an alert with a message. Whenever the job will start executing and at the end of a task you will receive a notification message. This helps you to know the status of the job. This section covers how to view running jobs.

How to view the running job status

  1. Click on Run Now  to start running the job. You will receive a notification after Infoveave start running the job, Click View to check execution status.

  2. Click Alerts & Notification  to view all job notification. Click View to check the execution status of respective job.

  3. After clicking on view, execution detail status dialog box will be displayed which consists of all tasks involved in it. You can view each individual tasks with their execution time and status.

In case of scheduling the job, this option helps you to check whether the job has executed and completed or not

  1. You can also view the Job running status from under Job Execution Status on the top-right corner of Infoveave.
    • It gives you the Information and statistics on all the jobs executed, with how many, executed, success, failed and scheduled.

Manage Infoveave Job

You can manage the Infoveave tasks with the options to, execute job, view run history, share, edit, move to a folder, add a description, and delete.

  1. Click Run Now  to start executing job. After clicking on run now, Infoveave send start execution notification. You will receive another notification whenever job execution finish.
  2. Click Run History to view overall as well as individual execution time and status of job with their tasks.
  3. Click Edit  to change the configuration of job.
  1. Share the job with the team/role from the share option.
    • Choose between the options
    • To share with the users, select the “share with users” tab. Pick the user(s) with whom the job needs to be shared from the share dialogue box.
    • Choose the “share with role” tab to make a job available to a certain work role. From the dialog box, choose a role.
    • Select the users from the presented list of users.
      • If you wish to share your job with all, then select Share With Everyone.
    • Select the user from the available list and click  to share the job.
    • To remove a particular user/role from the shared list, select the user/role and click  .

    • Click Save to share your job with the selected users.

      • Shared personals receive a notification after the successful share.
    • To unshare a job, just unselect users or uncheck the Share With Everyone.
  1. Edit any of your job with the Edit option.
  1. To move to a folder, create a folder by clicking the New Folder option, then drag the Job into the desired folder using the drag-and-drop feature.
    • You may also choose a folder from a drop-down menu by clicking the folder symbol on the Job.
  1. Click “Add Description” and fill out the description details to add a description to the Job.
    • Select the Editor Type.
    • Add necessary Tags (if required).
    • Add Description and Content.
    • Click Ok
  1. If you want to delete Job, click on Delete .
    • Type in “delete” in the text box.
    • Click Yes.