---
title: "How to create a new SQL job using SQL Server Management Studio?"  
description: "How to create a new SQL job using SQL Server Management Studio?"  
author: "Steilla Mitchel"  
published: 2024-07-16  
updated: 2024-07-17  
canonical: https://www.mindstick.com/forum/160940/how-to-create-a-new-sql-job-using-sql-server-management-studio  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 3 minutes  

---

# How to create a new SQL job using SQL Server Management Studio?

How to create a new SQL job using SQL Server [Management Studio](https://www.mindstick.com/forum/159668/what-is-the-difference-between-sql-server-and-sql-management-studio)?

## Replies

### Reply by Ashutosh Patel

#### SQL Server Job

There are several steps to create a new SQL Server job using SQL [Server Management](https://www.mindstick.com/interview/33968/how-to-clear-the-cache-in-sql-server-management-studio-ssms) [Studio](https://answers.mindstick.com/qa/116181/google-launches-workspace-studio-to-create-automated-gemini-powered-agents) (SSMS).

Here is a detailed guide to help you through the process.

#### Open the SQL Server Workstation (SSMS)

Start SQL Server Management Studio.\
Connect to the SQL Server instance where you want to create the job.

#### Access SQL Server Agent

In the Object Explorer pane, locate the SQL Server Agent. If it is not expanded, click the plus (+) sign next to it.\
Verify that SQL Server Agent is running. Otherwise, right-click the SQL Server Agent and select Start.

#### \
Create a New Job

Must read the [Component of SQL Server Jobs](https://www.mindstick.com/forum/160941/explain-the-component-of-sql-server-job) before creating the new SQL Job,

Follow the given steps if you familiar with the components of SQL Job

Right-click **Jobs** under SQL Server Agent.\
Select **New Job...** from the context menu. This will open the New Task window.

![How to create a new SQL job using SQL Server Management Studio?](https://www.mindstick.com/mindstickforums/5aded8bd-103c-4302-815d-26100006231a/images/1a5d173c-79ad-4d36-9eaa-e5ca62b0e6ea.png)

#### General Tab

As you can see, it has several steps, so let's go one by one. First, provide the **Job Name** and **Description** and click “**OK**”.

![How to create a new SQL job using SQL Server Management Studio?](https://www.mindstick.com/mindstickforums/5aded8bd-103c-4302-815d-26100006231a/images/903190c2-632c-44b1-9c38-79e7f7fa4043.jpg)

#### Steps Tab

The name of the step is **Steps** and it has a name, type and select Rez and type a command to save it to any location, and click “**OK**”.

![Create-and-schedule-a-job-in-SQL-Server4.jpg](https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/Images/Create-and-schedule-a-job-in-SQL-Server4.jpg)

#### Schedules Tab

Now click on the “**Schedule**” tab and provide the name, type, and frequency and click on **“OK”.**

![How to create a new SQL job using SQL Server Management Studio?](https://www.mindstick.com/mindstickforums/5aded8bd-103c-4302-815d-26100006231a/images/9072db73-a3d0-4d79-9bf7-4e09260a8c5b.jpg)

#### Alerts Tab

Now click on the Alerts tab and click on the “**Add**” button and provide the alert name, type, database name and click on “**OK**”.

![Create-and-schedule-a-job-in-SQL-Server6.jpg](https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/Images/Create-and-schedule-a-job-in-SQL-Server6.jpg)

#### Notifications Tab

Now click on the **Notifications** tab and choose what type of notifications you want.

![Create-and-schedule-a-job-in-SQL-Server7.jpg](https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/Images/Create-and-schedule-a-job-in-SQL-Server7.jpg)

#### Targets Tab

The last tab is the “**Target**” tab which shows you options for target servers, you can even select multiple target servers.

![Create-and-schedule-a-job-in-SQL-Server8.jpg](https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/Images/Create-and-schedule-a-job-in-SQL-Server8.jpg)

**Save the Job**\
Once you have entered all the required properties, click **OK** in the **New Task** window to save the task.

\
**Verify Job Creation**\
In **Object Explorer**, expand SQL Server **Agent** > **Tasks**.\
Make sure your new job appears in the list.

\
**Additional Tips**\
**Testing-** Once the job is created, you can test it by right-clicking on the job and selecting **Start Job at Step...** .\
**Monitoring-** Use Job Activity Monitor under SQL Server Agent to monitor job status and performance history.

\
By following these steps, you can successfully create and manage SQL Server jobs using SQL Server Management Studio.

**Also, Read:** [What is SQL server job, and why is it used?](https://www.mindstick.com/forum/160942/what-is-sql-server-job-and-why-is-it-used)


---

Original Source: https://www.mindstick.com/forum/160940/how-to-create-a-new-sql-job-using-sql-server-management-studio

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.