Hello,
Whenever a job stays in QUEUED state, it means thta Backup Exec is not able to get the DESTINATION in our case the TAPE Drive. There is a communication issue between Backup Exec and the Drive.
1 : Open Backup Exec, go to the Media Tab right click the Tape Drive and select disable, right click again and select Delete, Restart all the BE Services (This will force Backup Exec to search the TAPE again)
2 : Go to the Media Tab, right click the Server Name and click on Pause, and unpause it again.
Hope this helps !!!