Home > DeveloperSection > Blogs > Create sql server agent job to run stored procedure

Create sql server agent job to run stored procedure


Database Database  SQL Server 
Ratings:
0 Comment(s)
 401  View(s)
Rate this:
 Create sql server agent job to run stored procedure  

 

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 Studio.

 following the below steps

Step- 1

 right Click on jobs => New Job


Step-2
write  Job Name  My_Job  and job description.


Step-3
Click On Step Button



Step-4
Click on  New Button


Step-5
Write Step name and choose database name and write store procedure in command text box. after click to ok button.



Step-6
Click on Schedules button



Step -7
Click to new button Create New Schedules


Step- 8

Write Schedule name and set execution timing when you want to execute Job Scheduler.
and click to ok button.


Step-9
click to ok button complete your job scheduler creation process



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.



Step-11

Here your have done complete Job Creation process  . click to Close button



I hope this article help full for you.

Don't want to miss updates? Please click the below button!

Follow MindStick