I have a DTS task (which is a one-step ActiveX VBScript) which reads our database to send data to a business partner via XML. I have setup a job in the SQL Server Agent to start this task every 60 seconds.
This works 99% of the time, but on some occasions (as has just happened now), the job appears to get stuck. I didn't know until I had a phone call saying they had no data submissions yet today. When I look in Enterprise Manager, it says the job is running since yesterday at 12:48.
I have checked my code for endless loops, but there aren't any (it loops through a recordset with the usual "While not rs.Eof" code), so are there any other possible reasons?