Restore Single Log file works - But not "restore ... *.sqb"
I have 2 databases = call them DB1 and DB2.
I have 3 Log ship restore jobs, every 5 minutes 1 job restores DB1 and another job restores DB2. The logs for DB1 are then moved to a seperate directory and on a daily basis job 3 is supposed (and has been for some months now) to restore those to DB1 and move the files someplace else.
Now job 3 has given up. Running the sql by hand doesn't work either - it just hands there. Copying in the actual name of the next file to restore works fine. The other 2 jobs that run every 5 minutes and restore *.sqb work fine.
Probably clear as mud:
Job 1 - 5min schedule - Restore log db1 from disk = 'x:\dir1\Log_db1_*.sqb' with standby... moveto 'x:\dir2'
Job 2 - 5min schedule - Restore log db2 from disk = 'x:\dir1\Log_db2_*.sqb' with standby... moveto 'x:\dir2'
Job 3 - Daily 0600 Restore log db1 from disk = 'x:\dir2\Log_db1_*.sqb' with standby... moveto 'x:\dir3'
Jobs 1 and 2 fine, job 3 killed after 28 hours, won't function. Run just as code in QA hangs. Run with explicit filename - runs fine. With the _*.sqb this one just does nothing, no files are moved etc etc.
Any help gratefully received