In SQL Server 7 I am trying to use a scheduled DTS to export data to flat files every 10 minutes for another developers application to pick up.
I find that occasionally the Job is still executing and therefore it stops running.
Is there anything that I should be doing?
BTW. The other application is not yet switched on so I doubt that it is caused by access to the output file.
