RE: Keep Package Running if Webclient has Timeout

SSC Guru

Points: 323504

August 22, 2012 at 12:13 pm

i think what you want is instead of the web client, say executing a stored procedure that does a bunch of work, you want to have the web page activiate a service broker you would create;

the web page would get it's answer instantly that the service broekr was triggered, but the long process would be tripped by the broker, and would not worry about the web page timing out.

the service broker would execute the procedure or other process, and that's what we are after, right?

if you give a little more detials, i'm sure we could come up with a sample script for creating the broker and triggering the script? job? procedure?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!