Overview

In this lesson, we are going to see how to create and associate jobs from database in Wayfast.

What is a Job in Database?

A Job is a container that allows packaging one or more steps in process that need to be scheduled and executed. In other words, we can say that it is a series of query actions that can be performed in certain periods of time.

We can use jobs to define different tasks that can be run one or more times and monitored for success or failure. A job can run on one local server or on multiple remote servers.

How to create a Job in Wayfast?

Let’s go to “Database” at top menu, click on “Jobs” tab

Job’s dashboard will display all the details related. Click on “New” button to start with the creation.

A popup is displayed with only 2 fields to complete. Include the job’s name and description and check the “Active” checkbox before clicking on “Submit” button

Object is now created on Wayfast. Let’s focus on the “Quantity Steps” and “Quantity Schedulers” columns. Both indicate what are going to be steps setup for the job and the time-scheduled details respectively.

Let’s focus on “Quantity Steps”. Click on the “0” link and automatically a new popup is prompted to display all the steps related to job. In this case, it won’t display any row.

Click on “New” button again inside the “Job Step” popup and complete the required fields

After selecting the “Instance” and “Database” information, add the query to execute in the first step on the job. Make sure that the “Active” checkbox is checked in order to include the step in the job.

Now that we have 1 step associated, turn to “Quantity Schedulers” column.

Notice that Scheduling jobs defined the condition or conditions that cause the job to start running without user interaction. We can schedule a job to run automatically by creating a new schedule datetime.

Click on “0” link

A new popup is displayed on the screen to create the job’s scheduler. Click on “New” button

Before creating the job scheduler, let’s check the following options that Wayfast give us:

Now that we know better the different options, make sure that the job’s scheduler is active before clicking on “Submit” button. We should check the “Turn On” checkbox to active the scheduler.

New scheduler is created and associate it to the job previously created.

Recap

During this lesson, we learnt how we can setup a simple job with the steps to be executed automatically by the system in Wayfast. Also we setup a simply scheduled program for each of this jobs.