Scheduling stored procedures

Discussion in 'Databases' started by MayurGondaliya, Apr 29, 2008.

  1. #1
    Is there anyway we can schedule MS SQL stored procedures without using MS SQL Agent?
     
    MayurGondaliya, Apr 29, 2008 IP
  2. flippers.be

    flippers.be Peon

    Messages:
    432
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Depends on how you want to trigger them.
    From within the database themselves you have to use Agent.

    You could also just use the windows scheduler that will run a batch file on a specified time which connects to the database and executes the stored procedure using SQLCMD.exe
     
    flippers.be, Apr 30, 2008 IP
  3. mg1313

    mg1313 Peon

    Messages:
    532
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #3
    At my work I used Coldfusion server to schedule a Coldfusion page to run at some interval. That CF page had code to run a stored procedure...

    Pretty fast so I didn't have to wait for the database guys to schedule a job in SQL server (which took days)...
     
    mg1313, May 2, 2008 IP