Introduction

This article teaches how to schedule a new job in SQL Server that can be scheduled to run at a specific time. Here we use SSMS to create and schedule a new job.

What is a SQL Job?

A SQL Job is a feature in Microsoft SQL Server that allows you to automate the execution of one or more SQL scripts or other tasks on a scheduled basis or in response to specific events.

SQL Jobs are created using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL) scripts and can be scheduled to run at specific times or intervals, such as daily, weekly, or monthly. They can also be configured to run in response to events such as system startup, database backup completion, or the completion of another SQL job.

SQL Jobs can be used for a variety of purposes, such as database maintenance tasks, data integration, or report generation. They can be a valuable tool for improving the efficiency and consistency of your database management tasks. Some examples of SQL Jobs are automatic weekly backup, sending auto emails, newsletters, writing log files, and audit logs.

Getting Started

First of all, start SQL Server Management Studio. Expand the Databases node and select a database you want to use to create and schedule a job from.

Create-and-schedule-a-job-in-SQL-Server1.jpg

How do we Create a Job in SQL?

For this database, I am going to create a job and schedule that job.

Now click on SQL Server Agent and select "Jobs", and right-click and click on "New Job".

Create-and-schedule-a-job-in-SQL-Server2.jpg

As you can see, there are many steps, so let's go one by one. First, provide a job name and description and click "OK".

General Tab

Create-and-schedule-a-job-in-SQL-Server3.jpg

Now click on "Next". The step name is Steps and provides a name, type and select the database and write a command to save in a location and click "OK".

Steps Tab

Create-and-schedule-a-job-in-SQL-Server4.jpg

Now click on the "Schedules" tab and, provide name, type, frequency, and click "OK".

Schedules Tab

Create-and-schedule-a-job-in-SQL-Server5.jpg

Now click on the alerts tab and, click on the "Add" button and, provide the alert name, type, database name, and click "Ok".

Alerts Tab

Create-and-schedule-a-job-in-SQL-Server6.jpg

Now click on the notifications tab and select how you want notifications.

Notifications Tab

Create-and-schedule-a-job-in-SQL-Server7.jpg

The final tab is the "Targets" tab which shows you the options of the target server; you can also select multiple target servers.

Targets Tab

Create-and-schedule-a-job-in-SQL-Server8.jpg

Summary

In this article, we learned how to create a new job in SQL Server.