How to execute a Stored Procedure in automatic / periodic way?

Discussion in 'Databases' started by fruisenor, Aug 7, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,:confused:
    I have a Stored procedure that should be running every hour (to reset some values in a table) but I am not able to find the SQL Agent on the SQL Manager Explorer, so is there any way to set the SP to run every hour on the DiscountASP MS-SQL 2008 database? Or any other alternative?
    Thanks in advance.
     
  2. Hi,
    The only way I know how to do this would be to create a code page that uses the SP.
    Then use the Scheduled Task feature in the Control Panel to hit that page.
    https://my.discountasp.net/scheduled-task.aspx
    All the best,
    Mark
     
  3. Recommendation is working

    Mark,
    Excelent! It resolved my problem.
    Thank you very much!
    :)
     
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