Post reply

Triggering Stored Procs via ASP

  • October 30, 2001 at 10:00 am

    #77874

    Don't kill me. I know this should be a question for an ASP forum.

    Can I trigger a stored procedure that takes 30 minutes to complete via a ASP page and then just keep refreshing another page to check a value in a table for the Stored Procedure to fill when complete. Any Examples? Is there any easy way to do this?

    Thanks

    JNunezNYC

  • October 30, 2001 at 10:44 am

    #419502

    Sure. Assuming you're using ADO, just do something like this:

    cn.execute "whatever sp"

    Then start polling.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • October 30, 2001 at 12:38 pm

    #419508

    Might be better to use an ASP page to insert a "start" value in a table. Then let a scheduled task check for this and run the stored procedure. Let the stored proc update the table and then 2nd page can then check the table.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply