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

write  Job Name  My_Job  and job description.

Click On Step Button

Click on  New Button

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

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.

click to ok button complete your job scheduler creation process


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.


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

I hope this article help full for you.
  Modified On Mar-14-2018 01:30:11 AM

Leave Comment