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

Posted on 2011-04-20
Last Modified: 2012-06-21
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?
Question by:TonyReba
    LVL 18

    Assisted Solution

    LVL 2

    Assisted Solution

    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.
    LVL 21

    Accepted Solution

    Create SQL job and for Job source is SP. Schedule it.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now