Triggering Stored Procs via ASP

• jnuneznyc

  SSC Rookie

  Points: 44

  More actions

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  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