ASP.NET and MS SQL

MacroGuru · 01-19-2005, 06:15 PM

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 · 01-19-2005, 06:38 PM

english plz ok tks

(sorry)

MacroGuru · 01-19-2005, 06:46 PM

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.

Solecismic · 01-19-2005, 07:10 PM

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 · 01-19-2005, 08:51 PM

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 · 01-19-2005, 11:13 PM

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.

01-19-2005, 06:38 PM	#2
Pumpy Tudors Bounty Hunter Join Date: Oct 2000 Location: Pittsburgh, PA	english plz ok tks (sorry) __________________ No, I am not Batman, and I will not repair your food processor.

01-19-2005, 06:46 PM	#3
MacroGuru Coordinator Join Date: May 2003 Location: Utah	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. __________________ "forgetting what is in the past, I strive for the future" Last edited by MacroGuru : 01-19-2005 at 06:47 PM.

01-19-2005, 08:51 PM	#5
VPI97 Hokie, Hokie, Hokie, Hi Join Date: Mar 2001 Location: Kennesaw, GA	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) __________________ CT & Jivin - "Surprisingly Entertaining"

01-19-2005, 11:13 PM	#6
MacroGuru Coordinator Join Date: May 2003 Location: Utah	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. __________________ "forgetting what is in the past, I strive for the future"

01-19-2005, 07:10 PM	#4
Solecismic Solecismic Software Join Date: Oct 2000 Location: Canton, OH	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)