Running A SP In Background (Asynchro)

Hi all,

I'm calling a PHP page that run a stored procedure. The SP contains a xp_cmdshell command that runs a DTS package. This DTS package is HUGE and will take many hours to import tables from an Oracle database to SQL Server. But I don't want my PHP page to "hang" in the process...

How can I execute my PHP page and refresh it every 30 seconds to see if the importation is done ? In my actual code, I create a "start_file.txt" when I begin the importation and a "end_file.txt" when it's done. I want to refresh every 30 seconds to see if the "end_file.txt" is created and display a "Importation Done!" message.

To be able to do that, I need the DTS Package to run in the background of the web server, or asynchronously from my PHP page.

Simple (stupid) question: is it possible to create a SP to call my main SP so it will run independently ??

Let's review some of my code here.

Part of my PHP page:
$DTS_result = $dbj->Execute(mssql_query("EXECUTE Run_DTS_Packages"));

My Stored procedure (without username & password...):
CREATE PROCEDURE Run_DTS_Packages AS
exec master.dbo.xp_cmdshell 'C:Progra~1Micros~380ToolsBinnISQL.EXE -S RHEA -U user -P pwd -Q "ISQL_Batch ''D:DDFIImporteIMPICAFI.bat''" -n -d DDFI'
GO

Any help will be greatly appreciate !!

CFGilles