How to Schedule a Stored Procedure?

Discussion in 'Databases' started by cscordo, Aug 15, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cscordo

    cscordo

    I have a small stored procedure which needs to be executed daily on my database; Its a pain to run it manually every day.

    Is there a way to schedule the stored procedure to run against SQL 2005 on dASP?

    I guess I need access to SQL Agent, correct?
     
    cscordo, Aug 15, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    We do not allow SQL Scheduled Jobs because of potential security issues.

    You can consider using the scheduled task tool.

    - Build a simple asp / asp.net page the call the stored proc on your website
    - Use the scheduled task tool in the control panel to call the page.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Aug 15, 2007
    #2
  3. cscordo

    cscordo

    Aha-

    So basically, I can have an ASPX page run that stored procedure; And then schedule that ASPX page to get accessed via the dASP Scheduled Task tool?

    neato.
     
    cscordo, Aug 15, 2007
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page