Log Shipping restore job runs indefinitely
I've watched this as it's happened, and when it comes across this condition, there are files waiting to be restored. The problem is that the job doesn't ever finish. SQL Server shows it in an "Executing" state, while the SQL Backup GUI show it "Successful". Subsequent restore jobs therefore do not run.
After restarting SQLServerAgent, I manually launch the job and it runs just fine, and will continue to run subsequent jobs for a while. Eventually, this condition is encountered again, and it requires me to manually restart SQLServerAgent and go through the same routine again.
I have seen this happen on a couple different instances of SQL Backup 5.3 on different servers that I manage. Any clue what could be causing the job (a) not to find files when they are there and (b) not to end if it doesn't find files?
Secondarily, is there any way to give the job a time limit (e.g. if it doesn't complete within 15 minutes, stop it)?
Running SQL Server 2005 and SQL Backup 5.3