---
title: "Create sql server agent job to run stored procedure"  
description: "This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server  by using SQL Server Management"  
author: "Anonymous User"  
published: 2016-03-07  
updated: 2018-03-14  
canonical: https://www.mindstick.com/blog/11027/create-sql-server-agent-job-to-run-stored-procedure  
category: "database"  
tags: ["database", "sql server"]  
reading_time: 2 minutes  

---

# Create sql server agent job to run stored procedure

This Article describes how to create a Microsoft [SQL Server Agent](https://www.mindstick.com/interview/879/what-is-sql-server-agent) job step that executes Store [procedure in SQL](https://www.mindstick.com/forum/158350/what-is-a-stored-procedure-in-sql-server-and-how-to-create-one) Server by using SQL Server [Management Studio](https://www.mindstick.com/forum/159668/what-is-the-difference-between-sql-server-and-sql-management-studio).

##### following the below steps

**\****Step- 1****\** right Click on jobs => New Job**\**![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/6c6eebdb-4009-4ae7-ace4-dff6b6dbf257.png)**\****Step-2**write Job Name My_Job and job description.![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/bb493df8-b9a3-4200-9766-9fcda02723af.png)\
\
**Step-3**Click On Step Button\
![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/b93a7ec2-0b0c-4ade-9dd3-c545407837fb.png)\
\
**Step-4**Click on New Button![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/5e4e3ccb-a588-4d8b-8699-ff1c532f2a89.png)\
\
**Step-5**Write Step name and choose database name and write [store procedure](https://www.mindstick.com/forum/193/auto-increment-by-store-procedure) in command text box. after click to ok button.\
![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/70b3619b-4190-495c-9366-5b9e6e29b62d.png)\
\
**Step-6**Click on Schedules button\
![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/38e71669-3cb1-4fd6-90bf-458e0cc4404e.png)\
\
**Step -7**Click to new button Create New Schedules![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/00240ae7-4f9c-4f55-a3c4-a168321fefc9.png)\
\
**Step- 8**\
***Write Schedule name and set execution timing when you want to execute Job Scheduler.***and click to ok button.![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/81856a19-e3b3-4ab1-b510-ec7af607880e.png)\
\
**Step-9**click to ok button complete your job scheduler creation process![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/8929683e-84aa-462f-8cd3-268121aadb1a.png)\
\
**\****Step-10**\
Click on your job name which you have created.Right click on your job name which you have created. and click on Start job at step.\
![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/0bf9fd67-997a-4e0e-be1f-a8860d063fe0.png)\
\
**Step-11****\****Here your have done complete Job Creation process . click to Close button****\**![Create sql server agent job to run stored procedure](https://www.mindstick.com/blogs/9c2160ed-e328-4b0c-a182-89ecb6c995f0/images/aed108db-6121-4796-8ca2-72e279bc1516.png)**\****\*****I hope this article help full for you.***

---

Original Source: https://www.mindstick.com/blog/11027/create-sql-server-agent-job-to-run-stored-procedure

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