SP's Die before the end of Process

[aalmeida]

I have a Sequence of SP that die before the end of the process.
After a file is sent (FTP) from the mainframe a command line batch is called that call an VB app that start the process to import the Mainframe file, The File is imported a it's records are compared to a Table and if there is a matchin record is call a SP to export the file and FTP it to another destination.
The problem ocurrs when that are more than One destination witch means more than one file has to be FTPed, it goes all the way to BCP out the 1st File FTP it , BCP out the 2nd file and dies.
What I'm missing? how can I garantee it to run all the way to the last destination? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[aalmeida]

It seems to me that the Agent that originates the job call does not want to wait for the job to finish, is there a way to keep it running after they close the session to the ftp server? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"