---
title: "Scheduling a job in SQL."  
description: "A job is a series of action that SQL Server Agent Performs. In this blog , all required snapshot are  available to scheduled a query, through SQL Serv"  
author: "Abhishek Srivasatava"  
published: 2016-10-07  
updated: 2016-10-07  
canonical: https://www.mindstick.com/blog/11217/scheduling-a-job-in-sql  
category: "mssql server"  
tags: ["sql server 2008"]  
reading_time: 2 minutes  

---

# Scheduling a job in SQL.

## Scheduling a job in SQL.

A job is a series of action that [SQL Server Agent](https://www.mindstick.com/interview/879/what-is-sql-server-agent) Performs. It is used to schedule the query to run at specific time. It can be run on local drive or entire network.

**SQL Server Agent:** It is a [component](https://www.mindstick.com/articles/12262/learn-how-to-make-a-component-in-magento-2) of [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) Server which [schedules](https://answers.mindstick.com/qa/37886/how-many-schedules-are-there-in-constitution-of-india) jobs and handle other automated task. If it is in red colour with x it means it not started yet.

**Step 1:** Activating the SQL Server Agent:\
Right Click on it, select **start** button.\
![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/76563778-07c5-48cc-85e8-278cac5ec7c0.png)\

**Step 2:** Click on yes button for all popup windows.

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/cf44953a-321a-49e7-8376-980b2303ac6d.png)\
\

**Step 3:** Now SQL server agent is activated. Expand the SQL Server Agent, select job option and right click on it, select new Job.

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/74e36a26-44e8-47d2-af17-5d846b5bc5f2.png)\
\

**Step 4:** Page for the new job will be pop up. Fill the form under general category As shown in the snapshot

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/e9590dbe-9106-47c4-99a4-12ed10ab3090.png)\
\

**Step 5:** Now click on Steps page,

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/22e1f6bf-b207-488b-b582-ff737252a77e.png)\
\
**Step 6:** Click on new button and fill the details for general.

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/d942804d-ac45-4287-a345-56436dea87bc.png)\

\

**Step 7:** for the same page click on Advanced. Select the output file location and other [essential](https://www.mindstick.com/articles/12260/why-it-is-essential-to-be-proactive-about-your-retirement-financial-planning) [requirement](https://yourviews.mindstick.com/view/85169/becoming-an-influencer-requirement-of-skills-and-knowledge).

\
![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/679d0aaf-90fa-4a43-9159-932fab5968c6.png)\
\

**Step 8:** Click on ok button, now click on Schedules, new page will popup a click on new.

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/002c24e0-11ae-4b46-8aaf-184d9374a953.png)\
\

**Step 9:** Fill the form [as per your](https://yourviews.mindstick.com/story/4069/sleep-you-need-as-per-your-age) requirement as shown below.

![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/e7cfbb0a-4e7c-4dcf-a742-c9811d558b8c.png)\
\

**Step 10:** Similarly fill the form for Alerts, notification and targets page.

\
![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/665ef511-9d3c-41eb-a07d-329aaf997962.png)\
\
**Step 11:** Complete the process by clicking OK for each popup window. Your job will scheduled Successfully.\
\
![Scheduling a job in SQL.](https://www.mindstick.com/blogs/0ee9bc97-44a3-4f04-9a93-c5216a228084/images/f67686e1-49d8-4c11-a60f-7e14069ab45f.png)\
\

---

Original Source: https://www.mindstick.com/blog/11217/scheduling-a-job-in-sql

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