Execute a stored procedure from ASP page, but don't wait for it to complete?

[Richard Morey]

Hi..

I have written a stored procedure that take 5 - 8 minutes to fully execute..
I wrote this routine as a stored procedure because I started to create all
the functionality via ASP but I kept getting time out errors on my ASP page.
The problem is that when I call the stored procedure from the ASP page the
server waits for the procedure to complete before returning the ASP page..
Is there any way to avoid this? I would like the user to be able to trigger
the stored procedure and have the page returned right away..

Thanks,

Rich

 

[Bob Barrows]

Hi..

I have written a stored procedure that take 5 - 8 minutes to fully
execute.. I wrote this routine as a stored procedure because I
started to create all the functionality via ASP but I kept getting
time out errors on my ASP page. The problem is that when I call the
stored procedure from the ASP page the server waits for the procedure
to complete before returning the ASP page.. Is there any way to avoid
this? I would like the user to be able to trigger the stored
procedure and have the page returned right away..

Use SQL Agent to schedule the procedure to run as a job. Disable the job.
This is well-documented in Books Online

Then call the sp_start_job system stored procedure from ASP to start the
job. The job will run asynchronously.

The login you are using to connect from ASP will need to be granted
permissions to run that system stored procedure.

HTH,
Bob Barrows

 

[Chris]

have you tried the command objects adAsyncExecute parameter on execute

objCmd.Execute, , adAsyncExecut

I don't know if it works, but it is a parameter option.

 

[Richard Morey]

Hello,

This worked! Thanks..

Rich