none
Running Stored Procedure Automatically RRS feed

  • Question

  • Hi,

    I would like to run a stored procedure every 24 hours automatically.

    How could this be done?

    Any help would be really nice.

    Thanks in advance for helping me.

     


    Wook Tae Jung (Mistercarwash Inc)
    Thursday, November 18, 2010 5:24 PM

Answers

  • you can create a sql job and set its schedule as 24 hours or every day particular time and set its step as that stored procedure..
    check how to create a sql job here
    http://msdn.microsoft.com/en-us/library/ms191439.aspx
    • Proposed as answer by Naomi NModerator Thursday, November 18, 2010 5:32 PM
    • Marked as answer by Wook Tae Jung Thursday, November 18, 2010 5:37 PM
    Thursday, November 18, 2010 5:28 PM

All replies

  • you can create a sql job and set its schedule as 24 hours or every day particular time and set its step as that stored procedure..
    check how to create a sql job here
    http://msdn.microsoft.com/en-us/library/ms191439.aspx
    • Proposed as answer by Naomi NModerator Thursday, November 18, 2010 5:32 PM
    • Marked as answer by Wook Tae Jung Thursday, November 18, 2010 5:37 PM
    Thursday, November 18, 2010 5:28 PM
  • Thank you ramireddy.

    I will have a look on that article.

    Have a great day.

     


    Wook Tae Jung (Mistercarwash Inc)
    Thursday, November 18, 2010 5:38 PM