Open

Overview

In this lesson, we are going to see how to create and associate SQL Server Jobs in Wayfast.

Jobs play an important role as they allow us to schedule timer triggered processes.

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.

Open

Click on the “New” button and a popup will be displayed.

Let’s provide a name and description for the job and then 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.

Click on the value of the “Quantity Steps” column. As this is a new Job it shows “0”.

A popup is displayed to add or edit job’s steps.

Click on the “New” button to add a “Job Step”.

After selecting the “Instance” and “Database” information, add the query to execute as part of the first job step. The last field is checkbox that allows to activate/deactivate steps during the debugging process.

How to schedule a Job?

Schedules allow to set the date & time or the frequency for the job to run.

Now that we have 1 step associated, click on the value of the “Quantity Schedulers” column.

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

The creation popup will be displayed.

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

Now that we know better the different options, make sure that the job’s scheduler is active before clicking on “Submit” button.

The new scheduler will be reflected in the jobs dashboard

Recap

In this lesson we learnt how we can create a job, define steps and schedule executions. Jobs are crucial to enable features triggered without user interactions like nightly data migrations, data clean up, or any scheduled task.