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.
Pritesh Ghotkar
28-Mar-2018This is very great article...
Manish Kumar
02-Jun-2017It is great to associate with such a blog.