[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

How do I schedule a store procedure MS SQL Management Studio?

I have created a stored procedure that updates the status columns in a table in my Database,this status are changed during the day by an user using a web form, but I I want to schedule to execute a stored procedure every day at 11 pm , how could I do this?
3 Solutions
Just create a job, and under steps add new step, put in the name of the stored procedure in the TSQL, and schedule away. As long as the service account, or the account your running the job under has the correct execute permissions on the stored procedure, you should be good to go.
Alpesh PatelAssistant ConsultantCommented:
Create SQL job and for Job source is SP. Schedule it.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now