How to Create sql server agent job to run stored procedure

Hello Techies,

                     In this article i am going to describe how to create Sql Job in sql server to run stored procedure. Please follow the bellow steps for the same.

Step 1. 

• Open SQL Server management studio 
• Go to SQL Server Agent (for this you should have Admin rights and SQL Server should be professional edition)

Step 2. Enter Job Name and Description 

Step 3. Click on Steps button for next process

Click on image for better view. 

Step 4. Click on Schedules for setup Scheduling the job when it will be execute on server. 

Step 5 (For Execute Job Manually or Test)

• Find your Created job by Job Name in Jobs Folder in Sql Server Agent. 
• Right Click after select Job pop will be open
• In pop up click Start Job at Step. 
• After click on step progress Pop up window will be open.

And your job has been executed. If you have any query please comment on message box.

Happy Coding.