ASP.NET and MS SQL

[MacroGuru]

Alright,

I have a question in regards to the two.

Does anyone know or have they done the following.

I have a chk box, that if checked, and submitted it would run a SQL job.

Now, the previous developer said that there is not a way to detect if the job has ended, so he has a 3 minute loop routine running.

I am trying to see if anyone knows how to check if a job has finished, and run that way, so I can speed up this process.

Thanks

[Pumpy Tudors]

english plz ok tks

(sorry)

[MacroGuru]

Ok....

I have T1 that has told S to start..but It is confused and having issues. So it stands there with a Lp just hanging out for 3 mins.

What has to happen is the S needs to tell the T1 that it is no longer confused, and the issues is gone, thus ignoring the LP and moving faster. :D

[Solecismic]

No idea how ASP.net works, but this is a classic socket function. I can't imagine a new communications API would lack the ability to split off threads to listen for events.

[VPI97]

What kind of SQL job? Running a stored procedure? I'm assuming that it currently doesn't return anything...change that to return a completion code (or error code if that's the case) and call the procedure with the expectations of receiving the code being returned in recordset form.

If you expect the job to take a lot of time, be sure to temporarily change the timeout settings for the IIS server to accomodate the time (you should be be able to accomplish that programmatically if the app has admin rights)

[MacroGuru]

It's a SQL Job that calls a DTS package, the DTS Package runs a simple T-SQL statement, gathering information from several tables, and populating them in another table.

The job at most right now, is taking roughly 20 seconds max when called.