I have a challenging task.
Situation: A systems transfers data files to a folder and
updates the status in a SQL table. My duty was to pass
the files to another application and also update the
status table. I did it creating an updet and insert
trigger, that imports the files in the next application
using the stored proceder xp_cmdshell. This works fine.
The problem here is that cmdshell works seriell. This
means that if an import lasts for 1 min, the Sourcesystem
has to wait until it gets the returncode from
xp_cmdshell. But the sourcesystem has to ...