Scheduled Job Hung

• 
  After the backups complete, SQL Backup will proceed with the deletion of expired log files, the deletion of old msdb entries, the mailing out of the output if the MAILTO option is used, and saving the log.
  
  If you run sp_who2, can you see the connection status and if it's running, and if so, the command that's running? Was the log generated?
  
  Does the backup complete if you run the command manually via Query Analyzer?

  petey February 01, 2006 04:23

  - 0 +
• 
  The job finally completed - it took it about 2 hours and 30 minutes to finish after it finished the regular backups. That's a long time to delete some log files!

  appwright February 01, 2006 10:10

  - 0 +
• 
  Do you have a lot of files in the log folders? sp_delete_backuphistory's performance could be better too, e.g.
  
  http://sqlteam.com/forums/topic.asp?TOPIC_ID=36201

  petey February 01, 2006 13:07

  - 0 +

Add comment

Please sign in to leave a comment.