Waiting on Stored Procedures

[bassguy]

Hello all,

A quick question.

Typically with this code:


me.sqlconnection1.open()
me.cmd_mystoredProc.executenonquery
me.Sqlconnection1.close



my windows app will:
open the connection
run the stored proc, waiting for it to finish
Close the connection


I am trying to get the Stored proc to start and then go on without it, as I am not waiting for anything back and it is a lengthy procedure running as long as an hour.

any suggestions would be appreciated


Bassguy

 

[Zarcom]

Use threading. Start a new thread get the proc to run in that thread then go back to the main one to continue working with your app. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[bassguy]

I do not even need the app to be running anymore....I would like to kick off the stored proc and close down.

 

[RiverGuy]

I would post this question in the SQL forum as well.

 

[blweb]

Use a trigger or something of that sort in SQL and leave the application out of the picture all together if it needs to go off at a specific time.

If you need the app to start this SP, then you will need to create a thread and call it cause you are going to be expending the system process either way.

That really is your only 2 options.