PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET spawning a seperate process for a long running stored procedure from vb.net??

Reply

spawning a seperate process for a long running stored procedure from vb.net??

 
Thread Tools Rate Thread
Old 05-01-2007, 04:16 PM   #1
jobs
Guest
 
Posts: n/a
Default spawning a seperate process for a long running stored procedure from vb.net??


Im writing an SSIS script task using VB.NET. I'd like to be able to
initiate an oracle stored procedure call for a process that will run
for 8 hours, but I don't want my process to wait for it finish. In
fact, I'd like the ssis job to terminate after it launches it.

How can I do this using vb.net/ado.net?

How can I later electronically locate and track that process?

Thanks for any help or information.

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off