Scheduling stored procedure to run once every hour

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Chetan Thombare
    New Member
    • Nov 2011
    • 1

    Scheduling stored procedure to run once every hour

    I have one application, I need to pull the data from file to sql server 2008 in every one hour.
    I write one stored procedure for it.I want to call this procedure on time period of one hour.This will read all the data from file to sql table.

    Any help appreciated.

    Thanks in advance.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    You have to create the job and set the schedule for it to run. What did google tell you?


    ~~ CK

    Comment

    Working...